Re: Update Statistics in Maintenance Plans
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Mon, 25 Feb 2008 11:37:21 -0500
Jim,
The Maintenance Plan designer that I am running (SQL Server 2005 SP2, with
hotfixes) clearly allows this to be specified. Therefore, I suspect that
your servers are not all up to the same level and that is what is causing
your problem.
Of course, the client tools on the desktop also need to be up-to-date, just
in case you are using more than one computer to manage the servers.
Make sure that they are all up to SP2 and check the hotfixes as well.
RLF
"Jim B" <JB@xxxxxxxxxxxxx> wrote in message
news:DF8041DD-1646-47D4-AA7F-4D5DA125474E@xxxxxxxxxxxxxxxx
I'm in process of converting about 20 sites over from SQL2000 to SQL 2005.
I've detached, move the files, reattached the files without issue. I
always
create a maintenance plan for each site. One component of the plan is to
Update Statistics. As these are large databases (at least to us at
200-300
gigabytes) receiving new transactions on a 24x7 basis, we typically only
want
to do a 10-20% SAMPLE in updating statistics. This is to keep job run
time
at a minimum. What I've noticed is that in some installations of SQL2005
I
don't have the option to specify either a percentage or even a number of
rows
for the update statistics piece in the plan. I am changing all these
legacy files over to compatibility level 90 in the database properties.
Would appreciate any help in discovering why I don't have the option to
specify percentage sample to take. Thanks in advance.
--
Thanks, Jim
.
- Prev by Date: Re: Can you install Sql Server 2005 on windows XP Professional
- Next by Date: sql 2005 licenses
- Previous by thread: Re: SQL Server 2K5 Express and IIS in Vista
- Next by thread: sql 2005 licenses
- Index(es):
Relevant Pages
|
