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)

You rated this post out of 5. Change rating

2003-08-23

1,462 reads

Blogs

Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS

By

One of the nice things about the Microsoft Connector for Oracle is that it...

ChatGpt Experiments–Getting Documentation

By

I get asked questions by salespeople all the time. Usually this is because a...

A New Word: Jouska

By

jouska – a hypothetical conversation that you compulsively play out in your head –...

Read the latest Blogs

Forums

Need someone good at design a Florida driver license!

By lunabarajas816

How about making a Florida driver license?How easy to get the Florida driver license...

Really someone need the CPA Australia certificate in 2023?

By lunabarajas816

What is the CPA Australia certificate? Where to replica CPA Australia certificate fast?Duplicate the...

Who can help me design Engineering Council certificate?

By lunabarajas816

The core part of the company includes: consulting service department, marketing department, operation department,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers