61 reputation
114
bio website
location
age
visits member for 2 years, 3 months
seen Apr 24 '12 at 19:21

Jun
16
awarded  Nice Question
May
14
awarded  Famous Question
Oct
3
awarded  Notable Question
Jul
22
awarded  Popular Question
Apr
17
awarded  Supporter
Apr
17
comment High Disk I/O from sql server or is High disk I/O slowing sql server?
This is a good place to start. We are still running SQL Server 2000, we are in the process of upgrading but that won't happen for a few more months, so I don't have the PAge IO Latch waits counter to look at. Thanks again.
Apr
17
comment High Disk I/O from sql server or is High disk I/O slowing sql server?
I don't have a problem with the DBA he is one of the best DBA's I've worked with. And he's given me a list of high blocking stored procedures. But as I mentioned one of the procs that is causing a lot of blocking is "TempUpdateStateItemLong" which is a proc used by hte SQL Session state store. Its a MS proc, and it only updates a single table by the sessionID which is the indexed primary key on the table. Also at most this table has 2000-3000 records, so updates really should take no time at all.
Apr
17
comment High Disk I/O from sql server or is High disk I/O slowing sql server?
Its a NETAPP array connected to the sql server with Qlogic fiber HBA's.
Apr
13
awarded  Student
Apr
13
asked High Disk I/O from sql server or is High disk I/O slowing sql server?