Browse by Tags

How to use TSQL to find the size of total and free physical memory within the SQL Server?

Published 24 January 8 4:28 PM | SSQA.net

Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With...

Filed under: sql server, performance, memory, microsoft, dump, physical, tsql, select, css, size

/3GB /PAE and AWE blurb what is it you hear within your environment?

Published 25 July 7 9:6 AM | SSQA.net

You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From...

Filed under: sql server, performance, management, memory, microsoft, security, server, windows, awe, /3gb, pae