Running into an issue I could really use some help with and hoping someone here might be able to help out.
Here is what is going on. We have 3 servers. All 3 servers are mirrors of each other. Hardware and software. 64-bit, 64GB RAM, Quad cores, RAID 10 for Log Drives, RAID 5 for Data. Mirrors for Backups.
Raid 10 for tempdb and OS on two different logical drives. SQL Server 2005 Standard Edition w/ SP3 installed.
Now, for the time we will name these server DB1, DB2, DB3. DB1 & DB2 are running perfect. DB3 is having issues with Writelog wait times. We use Confio Ignite, and it is showing total daily wait times of roughly
18 hours per day. DB1 and DB@ are roughly 2-4 hours per day.
Now, everything I have read about writelog is that is a symptom of disk i/o bottlenecks. However, even w
View Complete Post