Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OLEDB Waiting and Blocking Expand / Collapse
Author
Message
Posted Sunday, June 7, 2009 6:30 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, May 25, 2014 3:47 PM
Points: 58, Visits: 462
HI i am facing a problem on a production server which is giving users slow query results and occassionial timeouts during 2hours in the morning.
i ran a trace, and sql nexus for the morning period and nothing to significant usually activity.
But nexus reports 99% active thread time on OLEDB and lock blocking with durations over 1 minute.
The cpu, disk and memory seem fine just a massive bottle neck on oledb and no stored procedure that looks like its killing any of the resources.

Any thoughts??
Post #730444
Posted Wednesday, January 13, 2010 5:49 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:55 PM
Points: 3,084, Visits: 1,431
Are you using SQL Server 2005 performance Dashboard?




My blog
Post #847282
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse