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...
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:...
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...
We need to shrink a 600GB database. The vendor has numerous fields defined as Decimal (28,12). They approved changing all Decimal to VarDecimal....
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...
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...
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...
I'm curious what other people are experiencing regarding how long it takes to backup databases of 500GB or more? Are you using SQL Server backup...
What is the best way to expand a database from one data file to multiple data files? I want to create multiple data files each on their own RAID 10...
As you may have noticed I've been posting a lot of questions lately related to tuning memory, disk, etc... We have a large project nearing its end...
We've been running UPDATE STATISTICS with FULLSCAN daily against databases that total 280GB. The small databases are no problem, but the largest...
We have a 100+GB database that eventually with grow to 500GB+. Reindexing takes a long time and the database is on a SAN. What things can be done...
My mind is mush after reading numerous papers on monitoring memory. Most of what I found was in regards to what DMVs and perfmon/sysmon counters to...
I want to see if we are having memory problems with our 64-bit server running 64-bit 2005 EE. Why would a DMV report AWE memory when AWE is not...
We've had problems recently where our SQL Server Agent service has stopped unexpectedly in both our 32-bit and 64-bit clusters. The following...
We use ArcServe to backup database .bak files to tape nightly. This product has worked well, but we have concerns that it will not be able to...
I need assistance understanding the locking being reported in a resource-list. In the list below is my understanding of the lock modes correct?...
I am unable to determine what resource a deadlock victim owned based upon the deadlock dump below. I thought the resource-list is supposed to...
Separate names with a comma.
