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