06 Jul, 06:38AM in sunny Singapore!
Home → IT Support and Tech Corner →

MS SQL Server 2005 = Memory Hog?

Subscribe to MS SQL Server 2005 = Memory Hog? 6 posts

Please Login or Signup to reply.
  • Shotgun
    Shotgun's Avatar
    5,652 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,553 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
    11,662 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
    745 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,652 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 Login or Signup to reply.