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

Content with tags Administration, Monitoring Rss

   Items 1 to 20 of 46    Older >>
 

Mini-Me

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2014/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 543 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more...  Read more...
By Sean Smith 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,695 reads

Eight Steps to Effective SQL Server Monitoring

If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.  Read more...
By Additional Articles 2013/08/26 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 4,434 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more...  Read more...
By Sean Smith 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,695 reads

Perform Routine Server Checks Using PowerShell

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...
By Additional Articles 2012/05/21 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 3,535 reads

Automating Daily Checks with Powershell

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...
By Warren Campbell 2011/12/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 10,517 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more...  Read more...
By Sean Smith 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,695 reads

Disk Space Report

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...
By Aditya Kota 2010/05/27 | Source: SQLServerCentral.com | Category: disk space
Rating: |  Discuss |   Briefcase | 3,709 reads

What SQL Statements Are Currently Executing?

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...
By Ian Stirk 2009/12/11 (first published: 2008/10/28) | Source: SQLServerCentral.com | Category: dmv
Rating: |  Discuss |   Briefcase | 47,461 reads

Tracking and Reporting Database Growth

An article from new author Lokesh Gunjugnur that shows how you can set up tracking for database growth on multiple servers and creating custom reports in Excel.  Read more...
By Lokesh Gunjugnur 2009/06/02 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 12,498 reads

Disk Space Report

This scripts helps to power you with the disk space monitoring for the Mount points. Hope this helps  Read more...
By Aditya Kota 2010/05/27 | Source: SQLServerCentral.com | Category: disk space
Rating: |  Discuss |   Briefcase | 3,709 reads

Introduction to Profiler

This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.  Read more...
By Jack Corbett 2009/04/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,168 reads

Mini-Me

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2014/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 543 reads

Mini-Me

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2008/11/13 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 426 reads

Mini-Me

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2008/11/13 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 447 reads

What SQL Statements Are Currently Executing?

This article describes a utility that allows you to identify what SQL statements are currently executing.  Read more...
By Ian Stirk 2009/12/11 (first published: 2008/10/28) | Source: SQLServerCentral.com | Category: dmv
Rating: |  Discuss |   Briefcase | 47,461 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,570 reads

Disk Space Usage and SQL Server Performance

Every extra byte of space you waste in your database causes a performance hit to your application. This article looks at disk space usage and how it affects performance.  Read more...
By Additional Articles 2008/01/08 | Source: Database Journal | Category: monitoring
Rating:  Rate this |   Briefcase | 6,670 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,633 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,886 reads
   Items 1 to 20 of 46    Older >>
 
Tags
sql server 7 (27)    
t-sql (9)    
miscellaneous (8)    
sql server 6.5 (7)    
configuring (6)    
performance tuning (3)    
programming (3)    
sql server 2005 (3)    
advanced querying (2)    
backup / restore (2)    
database design (2)    
naming standards (2)    
powershell (2)    
replication (2)    
security (2)    
stored procedures (2)    
strategies (2)    
auditing (1)    
database properties (1)    
disk space (1)    
distributed queries (1)    
dmv (1)    
dts (1)    
editorial (1)    
editorial - ipod (1)    
editorial - wmv (1)    
english query (1)    
errorlogs (1)    
excel (1)    
index details (1)    
indexing (1)    
installation (1)    
instance properties (1)    
openxml (1)    
performance monitoring (1)    
server settings (1)    
sql-dmo (1)    
triggers (1)    
updategrams (1)    
uptime (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)