http://www.sqlservercentral.com/Articles tagged SQL Server 7, 2000, Monitoring posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need. http://www.sqlservercentral.com/articles/Monitoring/3201/2007/09/06http://www.sqlservercentral.com/articles/Monitoring/3201/Monitoring in the real world. Roy Carlson concludes his series on space monitoring for your SQL Servers with a real world example of how he found a problem and fixed it. http://www.sqlservercentral.com/articles/Administering/2681/2006/11/09http://www.sqlservercentral.com/articles/Administering/2681/Trending the size data for your databases can be crucial when ordering new hardware or just ensuring that you can handle the load. In Part 3, Roy Carlson looks at how you get the sizes needed for your instances into Excel and generate a chart for trending of this important piece of performance data. http://www.sqlservercentral.com/articles/Monitoring/2680/2006/11/08http://www.sqlservercentral.com/articles/Monitoring/2680/Continuing with his series on monitoring space, Roy Carlson looks at checking the space in a folder to be sure your SQL Server databases never run out of storage. http://www.sqlservercentral.com/articles/Monitoring/2679/2006/11/07http://www.sqlservercentral.com/articles/Monitoring/2679/SQL Server will autogrow your databases as they run out of space. But the process doesn't manage space, nor does it check the free space on the drive. Allowing autogrow to grow unchecked and unmanaged will eventually use up all the free disk space and potentially crash your server. New author Mark Nash brings you his system for monitoring space usage and generating a report that eases this process. http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/2006/08/25http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/In this series of articles, you will learn the basics of installing Microsoft Operations Manager 2005 as well as how to use MOM to monitor SQL Server. This article takes advantage of virtualization. We will use VMware Workstation 5 to create the lab to introduce you to the basics of installing MOM to monitor SQL Server. http://www.sqlservercentral.com/redirect/articles/2228/2006/01/17http://www.sqlservercentral.com/redirect/articles/2228/Part I of this article illustrated how to monitor CPU usage of running processes on a local machine or from a remote machine. This article illustrates how to monitor the CPU usage of different running processes on different machines and collect the information in a database.http://www.sqlservercentral.com/redirect/articles/2160/2005/11/17http://www.sqlservercentral.com/redirect/articles/2160/SQL Server Profiler can correlate Microsoft Windows System Monitor (Performance Monitor in Windows NT 4.0) counters with SQL Server or SQL Server 2005 Analysis Services (SSAS) events. Windows System Monitor logs system activity for specified counters in performance logs. The first thing to remember is in order to have correlating information you need to obviously be in sync - in other words you must start the perfmon trace and profiler trace at the same time or else they won't match up.http://www.sqlservercentral.com/redirect/articles/2108/2005/10/19http://www.sqlservercentral.com/redirect/articles/2108/Joe has a bunch of small, easy to use scripts that can definitely be the beginning of a great set of monitoring tool. Amazing how much info you can gather with a little bit of code! http://www.sqlservercentral.com/articles/Administering/sevenmonitoringscripts/1024/2005/05/13http://www.sqlservercentral.com/articles/Administering/sevenmonitoringscripts/1024/Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL. http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/2005/02/18http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/SQL Server excels at quickly acquiring and releasing locks to allow as much concurrency as possible on the server. However there are times that one user will block another, which can be a source of great user frustration as well as making the system appear to be slow. Leo Peysakhovich brings us some great information and code on how you can monitor and deal with blocking on your SQL Server 2000 server. http://www.sqlservercentral.com/articles/Monitoring/monitoringblocks/1709/2005/02/10http://www.sqlservercentral.com/articles/Monitoring/monitoringblocks/1709/Andrew Zanevsky shares his trace-scrubbing procedures that make it easy for you to handle large trace files and aggregate transactions by type–even when captured T-SQL code has variations. SQL Server Profiler is a veritable treasure trove when it comes to helping DBAs optimize their T-SQL code. But, the surfeit of riches (I'm reminded of the Arabian Nights tale of Aladdin) can be overwhelming. I recently had one of those "sinking" feelings when I first tried to make sense of the enormous amount of data collected by traces on a client's servers. At this particular client, the online transactions processing system executes more than 4 million database transactions per hour. That means that even a 30-minute trace that captures "SQL Batch Completed" events results in a table with 2 million rows. Of course, it's simply impractical to process so many records without some automation, and even selecting the longest or most expensive transactions doesn't necessarily help in identifying bottlenecks. After all, short transactions can be the culprits of poor performance when executed thousands of times per minute.http://www.sqlservercentral.com/redirect/articles/1648/2005/01/11http://www.sqlservercentral.com/redirect/articles/1648/The system table, "sysperfinfo," is the representation of the internal performance counters of SQL Server. This article demonstrates how to retrieve and store information from "sysperfinfo" to a CSV file, so that it can be analyzed.http://www.sqlservercentral.com/redirect/articles/1593/2004/11/30http://www.sqlservercentral.com/redirect/articles/1593/One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects. http://www.sqlservercentral.com/articles/Administering/procedurecache/591/2004/11/19http://www.sqlservercentral.com/articles/Administering/procedurecache/591/Auditing in SQL Server is something that is becoming more and more prevelant, and will likely become more regulated over time. Dinesh Asanka brings us a new article on the basics of SQL Servers most powerful auditing configuration, C2 level auditing. http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/2004/11/03http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/Analyzing the data storage in SQL Server databases is a bit of an art. It's a skill that takes some time to develop given that the tools are rather limited. DBCC SHOWCONTIG is one of the few ways in which you can get some insight into how SQL Server has structured your table on the disk. Joe Sack brings us another of his top xxx techniques with his ten queries that you can use to analyze the results of this command. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/analyzingdatastoragetenshowcontigqueries/1438/2004/08/16http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/analyzingdatastoragetenshowcontigqueries/1438/Monitoring your SQL Servers is something every DBA must do. Checking job status, disk space, etc. is a frequent question seen in our forums. Pearl Knowledge Solutions has developed a product to help you easily setup monitoring on your servers from a web interface. SQLCentric gets 4 stars from author Bruce Szabo; read his detailed review on this fine product. http://www.sqlservercentral.com/articles/Product+Reviews/reviewsqlcentric/1432/2004/07/23http://www.sqlservercentral.com/articles/Product+Reviews/reviewsqlcentric/1432/SQL Server will autogrow your databases as they run out of space. But the process doesn't manage space, nor does it check the free space on the drive. Allowing autogrow to grow unchecked and unmanaged will eventually use up all the free disk space and potentially crash your server. New author Mark Nash brings you his system for monitoring space usage and generating a report that eases this process. http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/2006/08/25http://www.sqlservercentral.com/articles/Monitoring/monitoringdriveanddatabasefreespace/1415/Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up. http://www.sqlservercentral.com/articles/Administering/whichdatabasesarebeingbackedupanotherlook/1390/2004/06/09http://www.sqlservercentral.com/articles/Administering/whichdatabasesarebeingbackedupanotherlook/1390/Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others. http://www.sqlservercentral.com/articles/Disaster+Recovery/minidisasteracfailure/1370/2004/06/07http://www.sqlservercentral.com/articles/Disaster+Recovery/minidisasteracfailure/1370/Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps. http://www.sqlservercentral.com/articles/Monitoring/reviewofsqlsentrylite/1331/2004/04/12http://www.sqlservercentral.com/articles/Monitoring/reviewofsqlsentrylite/1331/New Author! We've run a couple articles on similar topics, this one takes a slightly different approach. It's a short article and has two scripts included. http://www.sqlservercentral.com/articles/Administering/monitoringfailedjobsteps/1301/2004/03/01http://www.sqlservercentral.com/articles/Administering/monitoringfailedjobsteps/1301/Are you using alerts to help you keep track of things? Are you using as many alerts as you should be? Jeremy has a great list of alerts that he considers so important they are on his 'best practice' list. Definitely worth reading. http://www.sqlservercentral.com/articles/Administering/alertalertbackupandrestorebaby/1253/2004/01/08http://www.sqlservercentral.com/articles/Administering/alertalertbackupandrestorebaby/1253/The second part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Administering/20010422115754/85/2003/12/25http://www.sqlservercentral.com/articles/Administering/20010422115754/85/The first part of Steve Jones's series on having SQL Server automatically report information to a DBA. http://www.sqlservercentral.com/articles/Monitoring/20010422115752/84/2003/12/24http://www.sqlservercentral.com/articles/Monitoring/20010422115752/84/Ever wanted to use the SQL Trace system stored procedures instead of Profiler, but got intimidated by the cryptic system stored procedure calls? Then this article is just for you. It will show you how to use SQL Trace system stored procedures and provide you with wrapper stored procedures, that can be used to quickly get server side traces up and running. http://www.sqlservercentral.com/redirect/articles/1214/2003/12/10http://www.sqlservercentral.com/redirect/articles/1214/Log Navigator 1.0, a passive SQL auditing system that uses the SQL Server transaction log, instead of triggers, to audit data changes has been released. http://www.sqlservercentral.com/redirect/articles/1135/2003/09/29http://www.sqlservercentral.com/redirect/articles/1135/Joe Sack returns (is back?) with some scripts you can use to log information you may need when disaster strikes. http://www.sqlservercentral.com/redirect/articles/1115/2003/08/22http://www.sqlservercentral.com/redirect/articles/1115/Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily. http://www.sqlservercentral.com/articles/Administering/createmaintenancejobwithaclickwithoutusingawizard/1102/2003/08/20http://www.sqlservercentral.com/articles/Administering/createmaintenancejobwithaclickwithoutusingawizard/1102/This is an update to v1.2 of the product which does monitoring of your SQL servers. Looks like it checks service status, jobs, disk space, some other things. (Not Reviewed)http://www.sqlservercentral.com/redirect/articles/1093/2003/08/01http://www.sqlservercentral.com/redirect/articles/1093/