Nov 22, 2017 | Performance Monitoring, SQL Server |
Continuing with the Azure SQL Database theme, in this short video David demonstrates how to setup alerts for an Azure SQL database and build a dashboard to monitor the metrics of your Azure SQL database You can download the free ebook: Putting Your Head in the...
Mar 25, 2010 | Performance Monitoring, SQL Server 2008 |
For those people who like to use the Activity Monitor in the SQL Server Management Studio GUI instead of, or along with, sp_who, sp_who2 and DMVs in SQL Server, it is not where you left it in SQL Server 2005. To view the activity monitor interface in SQL Server...
Mar 14, 2010 | Performance Monitoring, SQLServerPedia Syndication, Trace |
Recently I wrote a short post on the default trace in SQL Server. You can read that here. In this post I am going to discuss the advantages of a server side trace over the SQL Server profiler GUI. I’ll look at an easy method for creating server side traces,...
Feb 4, 2010 | Performance, Performance Monitoring, Trace |
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in SQL Server 2005 and beyond and it is enabled by default when you install SQL Server. It has a number of uses from auditing to capacity planning and I will...
Jan 31, 2010 | Performance, Performance Monitoring, SQL PASS, SQL Training |
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make chapter and user group meetings (like me) this can be an excellent way of getting some excellent SQL Server training. I only came across the...
Jan 11, 2010 | Performance Monitoring |
For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit running but SQL Server 2005 running on 32 bit.Having fired up perfmon I could not see the SQL Server 2005 counters which left me in a state of confusion. Having had a...
