Monitoring

5 Monitoring Queries for SQL Server

  • Article

Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in your head. Dennes describes how he uses T-SQL queries for solving problems, whether it involves fixing the problems of missing indexes, preventing unrestrained autogrowth, avoiding index fragmentation, checking whether jobs have failed or avoiding memory stress conditions.

2016-07-08

10,110 reads

Survey on SQL Server Monitoring

  • Article

If looking after the health of SQL Server is part of your responsibility, Redgate would love to hear your views on monitoring server health through this 10 minute survey. Complete the survey by May 15th to be in with the chance to win one of three $50 Amazon vouchers.

2015-04-28

7,309 reads

Centralize Your Database Monitoring Process

  • Article

SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keeping an eye out for problems. It comes into its own when you have figured out how to configure it to run on maybe hundreds of instances using Central Management Server. Dennes describes how to tame the system so that it scales.

2015-02-04

8,923 reads

SQL Monitor Metric: Processes in a runnable state (scheduler query)

  • Article

Use this script in SQL Monitor to determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.

2013-12-03

3,671 reads

The Ten Commandments of SQL Server Monitoring

  • Article

It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.

2013-05-13

8,102 reads

Blogs

New Blog post- Best practices for migrating Microsoft SQL Server databases to Amazon EC2 using CloudEndure Migration

By

  Check out my new blog post-Best practices for migrating Microsoft SQL Server databases to...

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Read the latest Blogs

Forums

Is there a way to link phpmyadmin with sql server 2014? And wp config issues.

By martinez10

Network situation: I need to build a w12 server environment. In that i have...

Cannot attach databases in folder after power outage

By cphite

We had a power outage on one of our hosts, and it unfortunately caused...

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

By Mohsin_A_Khan

Comments posted to this topic are about the item Understanding CRUD Operations on Tables...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers