Viewing 15 posts - 61 through 75 (of 120 total)
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 23, 2010 at 1:25 pm
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 23, 2010 at 10:18 am
Thanks Steve. Is there a stored procedure to use for defragmenting tables?
Thanks!
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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 -...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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.
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
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!
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 5:09 pm
Thanks for all the feedback. I think I have enough information to make a good case for upgrading our database server. I'm just a developer with the company and don't...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 11:07 am
The drive being used is an Iomega LDHD-UP (Prestige). It is 1Tb in capacity. It uses 'Hi-Speed USB' to connect which has a 480Mbps speed and it has an 8Mb...
Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;
June 16, 2010 at 10:42 am
Viewing 15 posts - 61 through 75 (of 120 total)