Home > IT Support and Tech Corner

MS SQL Server 2005 = Memory Hog?

• Shotgun

  12 May 08, 14:20

  I noticed my MS SQL has a tendency to occupy in access of 1GB of memory.  Does anyone else encounter this?  Sometimes it jumps up even to 2GB... =/

   

• Xcert

  12 May 08, 16:27

  Originally posted by Shotgun:

  I noticed my MS SQL has a tendency to occupy in access of 1GB of memory.  Does anyone else encounter this?  Sometimes it jumps up even to 2GB... =/

   

  
  Why did U even use MS-SQL in the first place?

• BrUtUs

  12 May 08, 16:31

  Originally posted by Xcert:

  
  Why did U even use MS-SQL in the first place?

  
  maybe he developer...

• GIB

  12 May 08, 19:13

  Maybe the 1GB is reserved by the MSSQL or you have set the minimum memory to 1GB.

  As for the 2GB issue, are you using a lot of temporary tables?

• Shotgun

  13 May 08, 16:43

  Eh, nope.  MS SQL Server is not my choice.  Its what the company is using, and works with ASP.Net applications.  I'm just the SA sounding off some alarms due to high mem usage. =/

   

• playmemory

  13 May 08, 22:08

  Most likely is the applications not very well written.

  meaning the SQL statement.