December 12, 2008 at 12:21 pm
Great idea. Thanks. I'll discuss that with the team. And thanks for the link.
- Cindy
December 12, 2008 at 12:53 pm
Why are you remoting into the server to run these queries? You should use SSMS on your local workstation instead.
I would be very concerned about moving temp files used by SSMS to build query results to the drive that contains my database files. That is just asking for I/O contention and performance issues.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 12, 2008 at 12:56 pm
See my explanation above as to why I am remoting in. As to moving them to the same drive, it's not actually the same drive. I was simplifying for the sake of clarity, but in fact the database files are on E: and the log files are on F:. I've moved my environment to D:.
- Cindy
December 12, 2008 at 1:07 pm
Okay - that makes sense. I did not see the other replies before I sent mine. I agree with Steve, you really should be looking at setting up a desktop that you can remote.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 7, 2010 at 2:10 am
Thank you very much, it's a surprising problem for me.
:satisfied:
April 3, 2017 at 11:38 pm
iskarta - Wednesday, April 7, 2010 2:10 AMThank you very much, it's a surprising problem for me.:satisfied:
We faced similar issue and below helped. Please try changing the disk where results are saved by changing the Default location for saving query results. Please check below link.
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply