Viewing 15 posts - 61 through 75 (of 121 total)
Do you think they aren't defragging them anymore? It could be cause the drives are so much bigger now that they can get away with not defragging them. It's kind...
June 24, 2010 at 7:52 am
How does this sound for a defrag procedure?
1. Boot any users who are on the system during its lowest usage window.
2. Turn off SQL Server.
3. Run the Windows Disk Defragmenter...
June 23, 2010 at 1:25 pm
We just completed an upgrade this weekend from 2000 enterprise to 2008 enterprise on Windows 2003 Enterprise Server and everything is fine now. You will need to run the upgrade...
June 23, 2010 at 10:35 am
Well I can report to the users here that the high cpu utilization was entirely due to not putting the new sql server directories into the McAfee Exclusion list. There...
June 23, 2010 at 10:18 am
Thanks Steve. Is there a stored procedure to use for defragmenting tables?
Thanks!
June 23, 2010 at 9:44 am
Aha! How I did it was I remoted into the server and opened enterprise manager and ran the alter table statements there. Should I have run EM on my local...
June 23, 2010 at 8:48 am
Steve Jones - Editor (6/23/2010)
Do you mean that the virtual drive is fragmented on the physical one or that inside the virtual drive it appears to be fragmented?
Thanks Steve -...
June 23, 2010 at 8:42 am
Ok..that clears that up. We don't use that kind of set up so my settings were in vain.
June 23, 2010 at 8:36 am
It was still running today when I came in. I exited out and reran it and it completed in a heartbeat. Go figure. Maybe the low memory was an issue...
June 23, 2010 at 8:35 am
What effect does the Query Timeout setting in SQL Server 2008 have? Is it related in any way to client timeout periods or is this for the internal locks? Our...
June 23, 2010 at 8:20 am
Thanks for that list MSzI! Our current build is 01.0.2531 so it appears then that there are several hotfixes that have come out since then. We have always waited until...
June 23, 2010 at 8:02 am
Hi folks. Thanks for chiming in on this. I looked at the Event Viewer yesterday and there were a lot of McAffee errors. There have been no errors since excluding...
June 23, 2010 at 7:24 am
I have 31Gb database that I have just set compatibility mode from 2008 to 2000 by first etting to single user mode then running:
ALTER DATABASE dbname SET COMPATIBILITY_LEVEL...
June 22, 2010 at 2:39 pm
It was an in place upgrade and we used the upgrade advisor. It didn't complain about much. We had 'DateInterval.Day' in some places that simply broke and we fixed those...
June 22, 2010 at 12:09 pm
I will change it to backup log this week. We're upgrading to 2008 on Saturday and that may break it.
Thanks for the feedback!
June 16, 2010 at 5:09 pm
Viewing 15 posts - 61 through 75 (of 121 total)