|
Home > Archive > MS SQL Server > March 2005 > Current Activity Window always times out on Sql Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Current Activity Window always times out on Sql Server
|
|
| freesoul777 2005-03-30, 7:03 pm |
| I always get this error 1222 time out if I go on my SQL Server and open
Enterprise Manager, go under management, Current acvtivity.
How do I set up SQL server to show me the activity.
The error is (both on server and client)
Error 1222 Lock request time otu period exceeded.
THanks
| |
| Jasper Smith 2005-03-30, 7:03 pm |
| This is because it switches out of READ UNCOMMITTED about halfway through
for whatever reason. Use sp_who2 in query analyzer instead. If you're
interested in locking/blocking check out aba_lockinfo
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"freesoul777" < freesoul777@discussi
ons.microsoft.com> wrote in message
news:74405E36-07ED-4A3A-88D8- 5E407505035E@microso
ft.com...
>I always get this error 1222 time out if I go on my SQL Server and open
> Enterprise Manager, go under management, Current acvtivity.
>
> How do I set up SQL server to show me the activity.
>
> The error is (both on server and client)
> Error 1222 Lock request time otu period exceeded.
>
> THanks
>
|
|
|
|
|