DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the
Read More...
Few counters and gotchas for you to look for when you are installing SQL Server clusters, also using SELECT statements & DMVs to get SQL instance information. Such as: Do not install SQL Server on a compressed drive, by default the installation will
Read More...
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
Read More...
How to know whether my indexes are being used or not? This is most interesting question I have come across through the forums since the SQL 2000 version usage days, you may not have easy way to find out using SQL Server 2000 or even you have to run a
Read More...