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

Content with tags Monitoring, T-SQL Rss

   Items 1 to 17 of 17   
 

Find failed SQL Jobs

Simple T-SQL to find failed SQL Agent jobs  Read more...
By free mascot 2013/01/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,893 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,049 reads

Find failed SQL Jobs

Simple T-SQL to find failed SQL Agent jobs  Read more...
By free mascot 2013/01/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,893 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,393 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,645 reads

Alert! Alert! Backup and Restore Baby!

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.   Read more...
By Jeremy Kadlec 2004/01/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,813 reads

Create Maintenance Job with a Click without using a Wizard

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.   Read more...
By Robin Back 2003/08/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,630 reads

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,897 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,204 reads

The SQL Server Black Box

Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.   Read more...
By Brian Knight 2003/04/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,269 reads

Managing Jobs Using TSQL

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...
By Randy Dyess 2003/04/02 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,663 reads

Managing Jobs - Part 1

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,434 reads

Auditing Your SQL Server Environment Part I

Ever been placed into a new environment and couldn't find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.  Read more...
By Randy Dyess 2002/04/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 10,350 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,645 reads

Executing a script from SQL Server

Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.   Read more...
By Steve Jones 2001/10/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,371 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,393 reads

Job to Monitor SQL Server 7.0 Performance and Activity

This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.   Read more...
By Additional Articles 2001/06/19 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,278 reads
   Items 1 to 17 of 17   
 
Tags
sql server 7 (12)    
administration (9)    
miscellaneous (6)    
performance tuning (5)    
advanced querying (4)    
configuring (4)    
security (2)    
stored procedures (2)    
affinity (1)    
backup / restore (1)    
cpu (1)    
database design (1)    
distributed queries (1)    
dts (1)    
english query (1)    
excel (1)    
graphs (1)    
indexing (1)    
installation (1)    
internals (1)    
naming standards (1)    
openxml (1)    
programming (1)    
replication (1)    
reporting services (ssrs) (1)    
schedulers (1)    
sql-dmo (1)    
strategies (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)