Post reply

How much RAM

  • October 30, 2008 at 7:57 pm

    #195309

    Ho much RAM does an SQL Login consumeon SQL 2005?

    I remember in SQL 2000 each connection to the database consumed 2KB.

    I'm not looking for a SUM of ram consumed by logins to the SQL Server, I'm looking for how much does an individual single login consume?

    Kindest Regards,

  • October 31, 2008 at 9:40 am

    #892421

    hi there check out slava,s blog -- http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

    Max worker threads setting does affect how much memory server will require under heavy concurrent load. Consider on x64 platform each SQL Server thread can consume 2MB of physical memory. So if you configure SQL Server for 2000 threads, under heavy load in addition to max server memory it might require additional 4GB of physical memory (2MB * 2000), it is even higher on IA64, i.e 8GB (4MB * 2000)

    looks like it is 2MB of physical memory per thread

    good luck

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply