I spoke with Microsoft regarding this issue and, after some research on their end, here is why waiting can occur when TASK_STATE is running. ·...
When joining sys.dm_os_tasks with sys.dm_os_waiting_tasks ON session_id AND exec_context_id I sometimes see a TASK_STATE of RUNNING with a...
It's a CX4 with fibre channel drives. Perfmon Avg. Disk Read Queue was usually around the mid 20's with a few quick spikes to 4,000+ Avg Disk Write...
We are evaluating SANs from EMC and HP. Our current EMC SAN is experiencing disk performance issues. To test performance of the new SANs we...
We are looking to implement a new SAN, either an EMC CX400 or an HP EVA 6400. In either case we are considering a storage pool technology. EMC...
I'm tuning our Update Statistics job and wonder if I should add logic to drop statistics on tables with zero records? Two reasons for this are:...
Avg. Disk Queue Length can be used to help determine if a bottleneck exists, but I'm not sure I understand how it will show the ratio between reads...
Thanks Luis. I wasn't sure if I needed to factor in the bytes in order to quantify the read/write load. Working with SSDs is new for me and because...
We are trying to assess if our application can be moved to Solid State Drives. In researching SSD we found that write-intensive applications are not...
Yes. We noticed it will not be supported after 2008. In this particular case it is vendor code so we don't need to be concerned about anything...
We need to shrink a 600GB database. The vendor has numerous fields defined as Decimal (28,12). They approved changing all Decimal to VarDecimal....
Here's an update. We opened a case with Microsoft in late January. They still have not been able to determine the cause of the problem. I did...
Frank, Any idea how your DR replication/mirroring is impacted during large reindexing operations? Just curious if the process/utility you are using...
We have 19 databases that total 915GB in data file size and 140GB in log file size. We anticipate about 250GB of growth each year. Our disaster...
Satya, We aren't experiencing deadlocks due to reindexing. I'm more curious if they are possible due to reindexing. Since a deadlock occurrs...
I know rebuilding an index can cause blocking due to the type of locking required for a rebuild, but are deadlocks also a possibility? I don't...
No I did not. Thanks Satya for pointing that out to me. I was experimenting with the DDL triggers yesterday in 2005. Very nice, although I quickly...
The error never returned for us so we did not pursue the matter. Dave
Thanks Elisabeth. We're looking at alternate high/semi-high availability options to a SAN cluster because we finally confirmed with EMC that our...
We have transaction log backups running every 15 minutes on a SQL 2005 Enterprise Edition - 64bit server. We would like to implement some type of...
Separate names with a comma.
