Reputation
Top tag
Next privilege 75 Rep.
Set bounties
Badges
1 1 4
Impact
~40k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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?