Technical Article

Track Long Running Queries

SQL2000 only.We use the attached script to schedule a SQL Agent job that sets up a Profile trace looking for long queries, and hourly imports them into a table.  This way we can historically (but with some degree of real time) look to see what queries put a load on the system.  We then allow […]

5 (1)

2003-08-23

1,443 reads

Blogs

Daily Coping 19 Oct 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Commenting a branching IF-THEN-ELSE.

By

I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an...

External Temp Tables Preventing Plan Reuse in Stored Procedures

By

Here’s an interesting issue that recently came up. We were seeing very high compilations...

Read the latest Blogs

Forums

Going Cloud Native

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Going Cloud Native

Change Tracking Default Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Default Retention

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers