Browse by Tags

SQL Server: How do I identify the queries that are worth tuning?

Published 16 November 7 7:2 AM | SSQA.net

Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...

Filed under: sql server, performance, management, microsoft, blogs, technet, dmv, dba, best practice, slow query

/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

How to find list of DMVs & DMFs?

Published 31 May 7 9:22 AM | SSQA.net

As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism...

Filed under: sql server, performance, management, microsoft, dmv, dba, dmf