[dba-SQLServer] Optimizing Stored Procedures and Views

David Emerson newsgrps at dalyn.co.nz
Sun Apr 2 21:49:11 CDT 2006


Cross posted AccessD SQL

SQL2000

Another thing I have noticed - When I view task manager, the first 
programme fluctuates between 80-90% of the CPU usage, but when run on 
the second database (the one which takes so long to process) the CPU 
usage sits on 99%.

Regards

David Emerson
Dalyn Software Ltd
New Zealand  




More information about the dba-SQLServer mailing list