13 Oct, 11:07PM in sunny Singapore!
Home → IT Support and Tech Corner →

MS SQL Server 2005 = Memory Hog?

Subscribe to MS SQL Server 2005 = Memory Hog? 6 post(s)

Please 登入 or 进行注册 to reply.
  • Shotgun
    Shotgun's Avatar
    5,885 posts since Jul '00
    • 12 May `08, 2:20PM

      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
    Mas Selamat Kastari
    Xcert's Avatar
    9,805 posts since Dec '01
    • 12 May `08, 4:27PM
      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?tongue.png

  • BrUtUs
    BrUtUs's Avatar
    12,453 posts since Apr '03
    • 12 May `08, 4:31PM
      Originally posted by Xcert:


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


      maybe he developer...

  • GIB
    GIB's Avatar
    844 posts since Dec '05
    • 12 May `08, 7:13PM

      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?

      Edited by GIB 12 May `08, 7:19PM
  • Shotgun
    Shotgun's Avatar
    5,885 posts since Jul '00
    • 13 May `08, 4:43PM

      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
    playmemory's Avatar
    191 posts since Apr '06
Please 登入 or 进行注册 to reply.