Posted by Aaron West on 07/17/06 23:50

PS.

SQL 2005 only.

And don't forget to cancel that long-running query, if you try it.

"Aaron West" <tallpeak@hotmail.no.spam.com> wrote in message
news:QuOdnWYPSs-QvSHZnZ2dnUVZ_vudnZ2d@speakeasy.net...
> Try this script to see what queries are taking over a second.
>
> To get some real output, you need a long-running query. Here's one
> (estimated to take over an hour):

> PRINT GETDATE()
> select count_big(*)
> from sys.objects s1, sys.objects s2, sys.objects s3,
> sys.objects s4, sys.objects s5
> PRINT GETDATE()

[Back to original message]