Home Menu
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Tomas Lind

Posts in Category ‘Monitoring’

  • 2015/10/19
  • 0 comments

Send email when log or data file grows

One way to keep track of your data- and log file sizes in SQL Server, is to send an email notification whenever a file growth occurs.

  • Posted in: Monitoring, Tips & Tricks
  • 2015/07/14
  • 0 comments

sys.dm_exec_cached_plans

The dynamic management view sys.dm_exec_cached_plans returns information on query plans currently in memory. This information can be useful for a lot of reasons: checking total memory allowed for cached plans, which plans aren’t getting reused, searching for certain query plan … Read more →

  • Posted in: Dynamic Management Objects, Monitoring, Tips & Tricks
  • 2015/05/15
  • 0 comments

Capturing Blocked Queries

In a previous post, I presented a solution for monitoring and logging long running queries in SQL Server. In this post I’ll show an extended version of that solution that also sends an email when a request has been blocked … Read more →

  • Posted in: Alerts, Blocking, Dynamic Management Objects, Monitoring
  • 2015/05/05
  • 0 comments

Capturing Long Running Queries

Long running queries in a database may or may not be a problem, depending on the type of system. In a data warehouse solution, queries that runs for several minutes may be perfectly normal and nothing to worry about. But … Read more →

  • Posted in: Dynamic Management Objects, Monitoring, Statistics
  • 2015/04/10
  • 1 comment

Capturing deadlock events

Traditionally, trace flags 1204 or 1222 are used to write information about deadlock events to the SQL Server log. But since SQL Server 2012, there is a default Extended Event session running called system_health that can be used instead. Extended … Read more →

  • Posted in: Deadlocks, Extended Events, Monitoring
  • 2014/11/19
  • 0 comments

SQL Agent Jobs Summary

A script that summarizes information about SQL Agent job execution history. Much in the same way as the Job Activity Monitor, but with some additional information. Also, this script allows you to run it from T-SQL solutions.

  • Posted in: Monitoring, SQL Agent
  • 2014/11/12
  • 0 comments

SQL Server Default Trace

The default setting in SQL Server 2005 and later is to keep a trace running all the time that captures basic information about the instance. This is called the Default Trace. The created trace files can be viewed in Performance … Read more →

  • Posted in: Configuration, Monitoring, SQL Profiler
  • 2014/11/03
  • 1 comment

SQL Server Alert not firing

When you set up SQL Server alerts on your SQL Server instance, make sure to run some tests to verify that they are actually firing when errors occur.

  • Posted in: Alerts, Monitoring
  • 2014/10/27
  • 2 comments

Performance Monitor Data into SQL Server tables

On a machine running SQL Server there are a lot of performance counters that can be used to create baselines or to investigate performance problems. Those specific to SQL Server can be sampled regularly from the system table sys.dm_os_performance_counters. But … Read more →

  • Posted in: Monitoring, Performance Monitor
  • 2014/10/23
  • 0 comments

SQL Agent job history gets deleted

Ever wondered why the SQL Agent job execution history gets deleted at regular intervals?

  • Posted in: Monitoring, SQL Agent, System Stored Procedures

confided data manager

Get compliant with the GDPR!


High Coast Database Solutions

High Coast Database Solutions

sql server consulting services


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • How to align columns in Notepad++
  • Manual failover in a SQL Server cluster
  • Export data from Excel to SQL Server
  • List SQL server roles by users
  • CDC Cleanup job

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Instagram

This error message is only visible to WordPress admins

Error: No connected account.

Please go to the Instagram Feed settings page to connect an account.

  • © 2022 Tomas Lind
  • Proudly powered by WordPress
  • Theme: Waipoua by Elmastudio
Top ↑