2
votes
5answers
295 views

Best practice disk usage for SQL Server

I've been reading that it is best practice to place the following on separate disks for performance and safety: tempdb database file log file backup files When you consider RAID using multiple ...
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 ...
1
vote
2answers
1k views

SQL Server database filled the hard drive and freeing up space isn't possible

I have a database in SQL Server 2008 on a 1Tb hard drive and it filled the drive, there is only 4Kb free. The MDF file is 323Gb and the LDF is 653Gb. The hard disk this DB is on has no other files on ...
2
votes
1answer
429 views

Tools for planning a SQL Database size requirement

I'm about ready to start setting up a SQL data warehouse for some SQL Server Analysis Services. The data that I am going to slice and dice lives in an off site database that I don't control, so my ...
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 ...
0
votes
2answers
146 views

What is the easiest way to get statistics on disk usage for my SQL Server database?

I have a SQL Server database with multiple hundreds of data tables in it, and I am looking for disk usage statistics, as it relates to each individual table. Is there a quick way to find this ...
1
vote
7answers
1k views

MS SQL Server and “No Hard Drive Space Left”

Got a server running a document delivery system on it. The machine is running extremely poorly (Windows XP). I've checked the regular things, like doing a memtest (turned out fine) and trying to ...
0
votes
3answers
4k views

How can I give a SQL Server user permission to run one stored procedure and nothing else?

I need to be able to remotely monitor the disk space on a SQL 2005 server. To do this I need to give a sql server user the ability to run the following stored procedure: EXEC xp_fixeddrives; ...
0
votes
2answers
2k views

How can I find the amount of free disk space only using SQL Server?

I have a SQL (2005) server for which I need to monitor the amount of free disk space. It is not currently running a web server so a normal ASP/.Net monitor page won't work in this case. Is there any ...
1
vote
3answers
375 views

Opening Trace in SQL Server Profiler Using Disk Space

I've got a server set up with a smaller c: drive for applications and a huge d: for storage. I've recently run a SQL Server trace using SQL Server Profiler and stored the results to file on the d: ...