SQL Server Management Studio

  • Log onto server Open SQL Server Management Studio (SSMS) Click About then Help To the right of SQL Server Management Studio match the Versions with the list below to determine your service pack level. SQL Server 2008 Service Pack 3 10.00.5500.00 SQL Server 2008 Service Pack 2 10.00.4000.00 SQL Server 2008 Service Pack 1 10.00.2531.00 SQL Server 2008 RTM 10.00.1600.20 SQL Server 2008 R2 Service Pack 1 10.50.2500.0 SQL Server 2008 R2 RTM 10.50.1600.1
  • January 10, 2010

    SQL Memory Leak Settings Work Around

    Microsoft SQL Memory Leak work around.  Microsoft SQL is a huge memory resource consumer there is no fix besides add more memory but there is a work around Microsoft provides 1.Log into the SQL Server using SQL Server Management Studio 2.Right click on the server go to properties 3.Click on the memory tab 4.Now the calculation is done in Megabytes 1024 MB is a gig 5.Subtract the system ram you want to leave free from your over all RAM. 6.I would leave at least 4 gigs of RAM free for the Operating System if possible. 7.The final answer is the number you type into the box that says “Maximum Server Memory (in MB)” 8.Click OK