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

Content with tag Monitoring Rss

<< Newer    Items 41 to 60 of 189    Older >>
 

SQLServerCentral Webinar #17: Monitoring your SQL Server Instances

Join SQL Server MVP Brad McGehee to learn why it is so important to monitor your SQL Server instances and what you should consider when starting out. This webinar will also show you how you can use Red Gate's SQL Monitor for SQL Server monitoring and will include an overview of the new features released in v3.0, including the ability to create your own custom metric definition and to support different access permissions.  Read more...
By Additional Articles 2012/04/11 (first published: 2012/04/05) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,014 reads

SQLServerCentral Webinar #17: Monitoring your SQL Server Instances

Join SQL Server MVP Brad McGehee to learn why it is so important to monitor your SQL Server instances and what you should consider when starting out. This webinar will also show you how you can use Red Gate's SQL Monitor for SQL Server monitoring and will include an overview of the new features released in v3.0, including the ability to create your own custom metric definition and to support different access permissions.  Read more...
By Additional Articles 2012/04/11 (first published: 2012/04/05) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,014 reads

sp_spaceused2

The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...
By Jason S Wong 2012/04/02 | Source: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,373 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 935 reads

Who did what?

This select will show the last sql statement for every open session plus many helpfull information.  Read more...
By mobasha B 2012/01/13 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,877 reads

Monitor Any Linked Server From SQL 2005

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...
By Sakthivel Chidambaram 2011/12/19 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,031 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,561 reads

Job Summary

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.  Read more...
By Adnan Korkmaz 2012/10/10 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,866 reads

Create a Monitoring Server for SQL Server with PowerShell

At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.  Read more...
By Additional Articles 2011/11/09 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,794 reads

An Easy Way to Monitor SQL Server Replication

In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.  Read more...
By Additional Articles 2011/10/26 | Source: Database Journal | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,800 reads

Disk Space Monitoring and Early Warning with PowerShell

Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.  Read more...
By Additional Articles 2011/09/12 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,457 reads

Preventing Problems in SQL Server

It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.  Read more...
By Additional Articles 2011/09/01 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 3,376 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/07/18 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,843 reads

Tracking processes

This script quick tip for those who will accurately monitor sessions on SQL Server.  Read more...
By Wellington Vitoriano 2011/08/16 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,567 reads

SQL Overview V - Monitoring Long Running Jobs

Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.  Read more...
By David Bird 2011/07/29 (first published: 2010/03/24) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 16,677 reads

SQL Overview VI - Monitoring Process Locks

In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.  Read more...
By David Bird 2011/07/22 (first published: 2010/03/31) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 15,097 reads

SQL Overview SSIS Package III - Full Package

Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s  Read more...
By David Bird 2011/07/15 (first published: 2008/01/22) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 20,487 reads

Monitor SQL Server Replication Jobs

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.  Read more...
By Additional Articles 2011/07/11 | Source: SQL Server Performance | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,730 reads

SQL Overview SSIS Package II - Retrieving SQL Error Log

In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.  Read more...
By David Bird 2011/07/08 (first published: 2008/01/14) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 17,405 reads

Email Long Running SPID Info

This script will email info about the longest running SPID in an HTML formatted table  Read more...
By Deon Benjamin 2011/07/07 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,889 reads
<< Newer    Items 41 to 60 of 189    Older >>
 
Tags
sql server 7 (55)    
administration (40)    
t-sql (14)    
performance tuning (11)    
sql server 2005 (10)    
miscellaneous (9)    
sql server 6.5 (7)    
configuring (6)    
jobs (6)    
powershell (6)    
auditing (5)    
advanced querying (4)    
backup / restore (4)    
dmv (4)    
replication (4)    
sql agent (4)    
asp.net (3)    
editorial (3)    
excel (3)    
indexing (3)    
integration services (ssis) (3)    
linked server (3)    
processes (3)    
programming (3)    
red gate software (3)    
scome (3)    
security (3)    
sql monitor (3)    
sql server 2008 (3)    
strategies (3)    
webinar (3)    
alerting (2)    
automation (2)    
blocking (2)    
blogs (2)    
cpu (2)    
database design (2)    
database size (2)    
default trace (2)    
disaster recovery (dr) (2)    
dts (2)    
dynamic management view (2)    
editorial - ipod (2)    
editorial - wmv (2)    
event logs (2)    
locking (2)    
naming standards (2)    
operations manager (2)    
performance monitoring (2)    
profiler (2)    
reporting services (ssrs) (2)    
reviews (2)    
schedulers (2)    
scom (2)    
sql trace (2)    
stored procedures (2)    
xml (2)    
activity (1)    
affinity (1)    
alerts (1)    
baselines (1)    
basics (1)    
capacity planning (1)    
change (1)    
change data capture (cdc) (1)    
clustering (1)    
code snippets (1)    
custom metrics (1)    
custom scripting (1)    
dac (1)    
data growth (1)    
database properties (1)    
database weekly (1)    
disk space (1)    
distributed queries (1)    
dynamic management views (1)    
editorial - mp3 (1)    
english query (1)    
enhancement (1)    
errorlogs (1)    
errors (1)    
extended events (1)    
failed logins (1)    
graphs (1)    
growth (1)    
hekaton (1)    
high availability (ha) (1)    
i/o (1)    
index details (1)    
information_schema.columns (1)    
information_schema.routine_columns (1)    
in-memory oltp (1)    
installation (1)    
instance properties (1)    
internals (1)    
ip (1)    
job (1)    
job activity (1)    
job history (1)    
mdw (1)    
metrics (1)    
missing indexes (1)    
on-call duties (1)    
openxml (1)    
oracle (1)    
orm (1)    
policy based management (pbm) (1)    
product reviews (1)    
production support (1)    
server settings (1)    
server side trace (1)    
size (1)    
sp_spaceused (1)    
sp_who (1)    
sp_who2 (1)    
space (1)    
space usage (1)    
sql response (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server error log (1)    
sql-dmo (1)    
sqlservercentral (1)    
stairway series (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
sys.objects (1)    
sys.syscomments (1)    
trace (1)    
transaction logs (1)    
transcation log (1)    
triggers (1)    
troubleshooting (1)    
updategrams (1)    
uptime (1)    
user defined function (udf) (1)    
what queries are running (1)    
xsl (1)