Tagged Questions
3
votes
1answer
54 views
tempdb logs on same drive as tempdb data or with other logs?
For many reasons I only have 3 hard drives (RAIDed and in an Always-On AG) for all my database files:
D: Data
E: Logs
F: Tempdb
Should the tempdb log file go on F: with the data file(s) or on E:?
...
2
votes
2answers
57 views
Moving one TempdB on 3 instance server
I have a large virtual SQL Server (Full 2008R2).
I run 3 SQL instances and would like to relocate the TempdB database file to another location, splitting off from the TempdB log file.
The trouble I ...
11
votes
2answers
827 views
System disk run out of space when running heavy SQL queries on SQL Server 2012
I'm quite new to SQL Server 2012, I would be grateful if someone can help.
I have restored a copy of a huge database to SQL Server 2012 and I tried to run some simple queries against it.
I'm trying ...
4
votes
2answers
2k views
SQL Server 2008 R2 - Set tempDB size on full disk
One of my SQL Server 2008 R2 instances had a job that went mad last night, ended up with the job auto-growing tempDB until it ran out of disk space. To compound the issue I noticed that tempDB is ...
