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

Content with tags Monitoring, Administration Rss

   Items 1 to 20 of 48    Older >>
 

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,776 reads

Index Utilization Trending

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?  Read more...
By Edward Pollack 2014/05/05 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,283 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 | 559 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,776 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,639 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,776 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,584 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,639 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,776 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,790 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 | 48,023 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,666 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,790 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,253 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 | 559 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 | 452 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 | 472 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 | 48,023 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,588 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,711 reads
   Items 1 to 20 of 48    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)    
indexing (2)    
naming standards (2)    
powershell (2)    
replication (2)    
security (2)    
stored procedures (2)    
strategies (2)    
auditing (1)    
database (1)    
details (1)    
disk space (1)    
distributed queries (1)    
dmv (1)    
dts (1)    
dynamic management views (1)    
editorial (1)    
editorial - ipod (1)    
editorial - wmv (1)    
english query (1)    
errorlogs (1)    
excel (1)    
indexes (1)    
installation (1)    
instance (1)    
missing indexes (1)    
openxml (1)    
performance monitoring (1)    
properties (1)    
server (1)    
settings (1)    
sql-dmo (1)    
summary (1)    
triggers (1)    
updategrams (1)    
uptime (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)