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

Content with tags Administration, Monitoring, SQL Server 7 Rss

   Items 1 to 20 of 29    Older >>
 

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,580 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,637 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,971 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,668 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,701 reads

Which Databases are Being Backed Up - Another Look

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.   Read more...
By Santveer Singh 2004/06/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,326 reads

Monitoring Failed Job Steps

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.   Read more...
By Leo Peysakhovich 2004/03/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,021 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,834 reads

Automatically Gathering Server Information Part 2

The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.   Read more...
By Steve Jones 2003/12/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,448 reads

Server side tracing in SQL Server, using system stored procedures

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.   Read more...
By Additional Articles 2003/12/10 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,686 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

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,668 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,920 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,205 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,275 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,671 reads

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!   Read more...
By Andy Warren 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,336 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,435 reads

The Case for SQL Logins - Part 1

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.   Read more...
By Andy Warren 2002/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,593 reads
   Items 1 to 20 of 29    Older >>
 
Tags
t-sql (9)    
miscellaneous (8)    
sql server 6.5 (7)    
configuring (6)    
performance tuning (3)    
programming (3)    
sql server 2005 (3)    
advanced querying (2)    
database design (2)    
naming standards (2)    
replication (2)    
security (2)    
stored procedures (2)    
strategies (2)    
backup / restore (1)    
distributed queries (1)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
openxml (1)    
sql-dmo (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)