Thursday, August 27, 2015

Tuning areas where we need to Look


Tuning areas where we need to Look

PAGEIOLATCH—DISK
CXPACKET—Big Queries
SOS_Scheduled_yield—Lots of functions may be missing Indexes
LATCH_EX—Parallelism or missing Indexes 
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...