Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Monitoring, SQL Server 7 Rss

   Items 1 to 20 of 60    Older >>
 

A Failed Jobs Monitoring System

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)  Read more...
By TJay Belt 2009/09/04 (first published: 2008/02/05) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 22,408 reads

Monitor Any Linked Server From SQL 2000

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000  Read more...
By Sakthivel Chidambaram 2008/07/11 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,429 reads

SQL Server DBA Fights a Demon

An interesting tale of David Bird's fight with tempdb.  Read more...
By David Bird 2008/03/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,583 reads

A Failed Jobs Monitoring System

One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem. (from Feb 2008)  Read more...
By TJay Belt 2009/09/04 (first published: 2008/02/05) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 22,408 reads

Monitoring on a Budget

Have you ever been asked for information you couldn't provide because you didn't have an historical monitoring tool? Try this  Read more...
By Bert Carles 2007/11/19 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 9,072 reads

Capturing Missing Information From SQL Profiler

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.   Read more...
By Solomon Rutzky 2007/09/06 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 9,380 reads

Monitoring File Sizes in SQL Server Part 4

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.   Read more...
By Roy Carlson 2006/11/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,639 reads

Monitoring File Sizes in SQL Server Part 3

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.   Read more...
By Roy Carlson 2006/11/08 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,889 reads

Monitoring File Sizes in SQL Server Part 2

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.   Read more...
By Roy Carlson 2006/11/07 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 6,973 reads

Monitoring Drive and Database Free Space

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.   Read more...
By Mark Nash 2006/08/25 (first published: 2004/07/01) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 42,684 reads

SQL Server and MOM 2005

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.   Read more...
By Additional Articles 2006/01/17 | Source: Database Journal | Category: monitoring
Rating:  Rate this |   Briefcase | 3,014 reads

Monitor CPU Usage of All Running Processes - Part II

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.  Read more...
By Additional Articles 2005/11/17 | Source: Database Journal | Category: monitoring
Rating:  Rate this |   Briefcase | 4,137 reads

The Steps to monitoring greatness

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.  Read more...
By Additional Articles 2005/10/19 | Source: Other | Category: monitoring
Rating:  Rate this |   Briefcase | 2,190 reads

Seven Monitoring Scripts

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!   Read more...
By Joseph Sack 2005/05/13 (first published: 2003/06/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 48,713 reads

Using Xp_sendmail With the Recipients Generated From a Query

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.   Read more...
By Kunal Das 2005/02/18 (first published: 2001/07/16) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 23,400 reads

Monitoring Blocks

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.   Read more...
By Leo Peysakhovich 2005/02/10 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 16,583 reads

Trace-scrubbing Tools

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.  Read more...
By Additional Articles 2005/01/11 | Source: MSDN Communities | Category: monitoring
Rating:  Rate this |   Briefcase | 1,721 reads

"sysperfinfo" in SQL Server

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.  Read more...
By Additional Articles 2004/11/30 | Source: Database Journal | Category: monitoring
Rating:  Rate this |   Briefcase | 3,015 reads

Stored Procedures and Caching

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.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,715 reads

Basics of C2 Auditing

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.   Read more...
By Dinesh Asanka 2004/11/03 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 26,779 reads
   Items 1 to 20 of 60    Older >>
 
Tags
administration (27)    
t-sql (12)    
miscellaneous (9)    
performance tuning (7)    
sql server 6.5 (7)    
configuring (6)    
advanced querying (4)    
sql server 2005 (4)    
programming (3)    
security (3)    
strategies (3)    
backup / restore (2)    
database design (2)    
dts (2)    
indexing (2)    
naming standards (2)    
replication (2)    
stored procedures (2)    
xml (2)    
basics (1)    
capacity planning (1)    
disaster recovery (dr) (1)    
distributed queries (1)    
english query (1)    
installation (1)    
linked server (1)    
openxml (1)    
product reviews (1)    
reviews (1)    
sql-dmo (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xsl (1)