SqlServer-QA.net

Audit trace is very helpful when you want to monitor a particular processes on your SQL Server, even for the successful logins and recent users activity on the databsaes. But the default trace would have many columns with the information and you need to know which column and table you need to get the relevant information. There is a difference ...

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). Then it comes what kind of practice you should deploy in order to obtain the ...

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read & write). November2007 magazine refers as follows: SELECT TOP 20 SUBSTRING(qt.text, ...

SYSMON aka PERFMON is a best tool to find out the system resources usage on a Windows server, similarly SQL Server 2005 has list of such useful DMVs to get you more information on many of the SQL Server-related objects, instances and counters by using the dm_os_performance_counters View. The results listed using this DMV will ...

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 of DMV is totally relies on calls to a set of Dynamic Link Libraries that ...