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,459 reads

Blogs

Goal Progress for Jan 2023

By

The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger

By

Does Context Info work across databases? This post shows it does. Another post for...

Introducing… Data On Rails!

By

Data On Rails is a Data On Wheels project designed to give a platform...

Read the latest Blogs

Forums

Identity column and "EntityID" column naming convention

By CreateIndexNonclustered

This is specific to 2022, but SQL in general. I will be joining a...

Replace Primary Server keeping same Log Shipping Server

By BobAtDBS

I have a two node SQL Standard 2014 Failover Cluster at the primary site. ...

Memory Issue With A SQL Server Express 2019 Server Database Application

By Rob Reid-246754

Hi, I have just moved a DB from an old HP laptop, to a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers