2
votes
4answers
286 views

Missing drive space in Server 2003

I have two drives used for SQL backups which for the last week have been acting strange - the free space indicated by windows is far off from what windirstat, etc indicates. There should only be about ...
0
votes
1answer
392 views

Windows Server hard disk writes slow down after about one minute

I'm copying a 130 GB SQL Server backup to my Windows 2008 server, and to start with I get write speeds around 80 GB/sec, which is about what I'd expect. However, after the initial burst about a ...
1
vote
3answers
1k views

Poor IO performance on SQL Servers in VMs

I have a small VM ESX 3.0 implementation - mostly test web servers, however there is 1 db server that gets terrible io performance. Will adding additional virtualized disks in a RAID help ...
0
votes
1answer
3k views

What does SQL Server's BACKUPIO wait type mean?

I'm using Sql Server 2008 ("R1"), with some maintenance plans that back up my databases to a network share. Some of my backup jobs show long waits of type "BACKUPIO". Of course it seems like this is ...
1
vote
3answers
812 views

Very slow harddisk performance

Today I was trying to execute a long-running (but highly optimized) query on a server in our company. I've run the same query on the same data on my home computer (5400rpm harddisk) and it took about ...
15
votes
3answers
22k views

Setting Low Disk Space Alerts on Windows Server 2008

I was wondering if there is an easy way to trigger an e-mail alert on Windows Server 2008 when any logical disk partitions become low on space. I have 2 SQL servers that have come close to running ...
3
votes
5answers
647 views

Optimal Disk setup for SQL Server

I've got a total of 8 physical disks I can use (not including 2 for the mirrored OS) for a fairly high-use SQL Server. It's used to serve a web-app (Win2k3, IIS6, ASP.Net) which has fairly heavy ...
2
votes
1answer
352 views

Can I predict the maximum writes per minute to a disk/RAID array

I've a database running on a windows server I'm monitoring with Hyperic. I see the writes per minute ramping up during the day as we approach our peak load. The peaks are increasing gradually over ...
1
vote
3answers
464 views

SQL Server Disk Write Performance

This question is from a developer, so it might be a simpleminded. We have a dev and prod sqlservers (2000) and I suspect the disk write times on the Prod server are quite slow. I've done the ...