blob: 4125534b7193583adfc9e67d0434091738eb58b6 (
plain)
1 SQL Server 2008 Memory Management
2 =================================
3 :author: Aaron Ball
4 :email: nullspoon@iohq.net
5
6
7 == {doctitle}
8
9 Once again, hello all: Recently I had a problem with SQL server. I was sifting
10 through the processes in Task Manager a few days ago ordered by memory
11 consumption. At the top of the list for memory consumption was SQL Server
12 (sqlserver.exe) weighing in at 200 megabytes of memory. I decided to look past
13 that one since 200 megabytes isn't too unreasonable for SQL, especially when
14 it's hosting the data for quite a few SharePoint web applications.
15
16 Today, I checked again. After my server had been online for two and a half
17 days, SQL server had grown to over 650 megabytes of memory (653,224 KB
18 specifically). Seeing as how I have not made any changes to my local SharePoint
19 environment in that time (I'm currently developing a non-SharePoint related
20 project), I decided to look into putting a cap on the memory consumption of
21 SQL. Originally I had 2 gigabytes of ram for my server. I added an extra
22 gigabyte to that and SQL took up the additional space.
23
24 As it turns out, one can put a maximun and a minimum limit on SQL. Here's how.
25
26 Open up SQL Server Management Studio 2008
27
28 Type in the information to connect to the server that has SQL server running on
29 it and click connect.
30
31 Right click the server name
32
33 image:files/MgmtStudio1.jpg[height=400]
34
35 Click Properties
36
37 Select Memory on the left side of the window that comes up
38
39 image:files/MgmtStudio2.jpg[height=400]
40
41 Under Server Memory Options, adjust the minimum and maxiumum memory settings to
42 what you need.
43
44 Click OK
45
46 Right Click the server name again
47
48 Select Stop from the menu
49
50 Click necessary buttons to get through the prompts
51
52 Right Click the server name yet again
53
54 Select Start from the menu
55
56 Click the necessary buttons to get through the prompts
57
58 And that's it. Mine (as in the screenshots) has yet to go over 300 megabytes of
59 memory consumption.
60
61 Thanks for reading.
62
63
64 Dirk
65
66
67
68 Category:Microsoft
69 Category:MsSQL
70
71
72 // vim: set syntax=asciidoc:
|
