network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 1 month |
| seen | Apr 24 '12 at 19:21 | |
| stats | profile views | 4 |
|
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? |
