Pagelatch_ex long wait time 
Author Message
 Pagelatch_ex long wait time

Hi all,

I just moved from my test environment to production.  I'm running win2k & sql2k.  My load of 3 million records ran in 55 minutes on test, but is now taking forever.

We have tried to emulate the test environment as much as possible, but I am still noticing bad performance.  

Whenever I look at the process, many times I see it waiting for pagelatch_ex. Can someone tell me what this is, and if it would be causing problems?  

Thanks for any help

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!

Fri, 19 Sep 2003 23:53:16 GMT
 [ 1 post ] 

 Relevant Pages 

1. Long time waiting for connection

2. Long time waiting for connection

3. Long Wait Time Access Small Access Database through ODBC

4. SQL statment takse a long long time...

5. Help Help My DBCC CheckDB run a long long time

6. Long waits on SQL 2000 Enterprise Manager

7. Merge Replication - How long schould I wait?

8. medium time automatically converted to long time.

9. Waited Too Long For Row Cache Enqueue Lock

10. waited too long for row cache enqueue lock

11. Session is waiting for long....

Powered by phpBB® Forum Software