DBCC CHECKDB: weekly

Showing posts with label weekly. Show all posts

Sunday, March 25, 2012

db_backupoperator question

I have assigned an user id to a role of db_backupoperator. But after I
created a scheduled job to do backup weekly, it won't run at all. No error
message in the event application. So I go to do the backup manually. I get
an error message when I click the "..." button to specify the backup file
location as following:
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Error 229: Execute permission denied on object 'xp_availablemedia',
database 'master', owner 'dbo'."
Please help. Thanks.Hi,
Its seems your login account does not have the permissions required to
create a backup
device in hard disk. Please consult your system administrator or database
administrator
to obtain the required permissions to write in to the hard disk (Write
permission on the folder you craete the backup file).
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> I have assigned an user id to a role of db_backupoperator. But after I
> created a scheduled job to do backup weekly, it won't run at all. No error
> message in the event application. So I go to do the backup manually. I
get
> an error message when I click the "..." button to specify the backup file
> location as following:
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Error 229: Execute permission denied on object 'xp_availablemedia',
> database 'master', owner 'dbo'."
> Please help. Thanks.
>|||Thanks, Hari. I have created the user id previously and didn't assign a
local win 2k user id to it. May be this is the problem. Now I just created
a local win 2k user id with the access right. But I don't want to delete the
sql user id and re-create it again? How can I map the current sql 2k user id
with the local win 2k user? Please let me know. Thanks.
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
> Hi,
> Its seems your login account does not have the permissions required to
> create a backup
> device in hard disk. Please consult your system administrator or database
> administrator
> to obtain the required permissions to write in to the hard disk (Write
> permission on the folder you craete the backup file).
> Thanks
> Hari
> MCDBA
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> > I have assigned an user id to a role of db_backupoperator. But after I
> > created a scheduled job to do backup weekly, it won't run at all. No
error
> > message in the event application. So I go to do the backup manually. I
> get
> > an error message when I click the "..." button to specify the backup
file
> > location as following:
> >
> > Microsoft SQL-DMO (ODBC SQLState: 42000)
> >
> > "Error 229: Execute permission denied on object 'xp_availablemedia',
> > database 'master', owner 'dbo'."
> >
> > Please help. Thanks.
> >
> >
>|||Hi,
The user in which you start the SQL Server and SQL Agent service should have
the permission.
Thanks
Hari
MCDBA
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> Thanks, Hari. I have created the user id previously and didn't assign a
> local win 2k user id to it. May be this is the problem. Now I just
created
> a local win 2k user id with the access right. But I don't want to delete
the
> sql user id and re-create it again? How can I map the current sql 2k user
id
> with the local win 2k user? Please let me know. Thanks.
>
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Its seems your login account does not have the permissions required to
> > create a backup
> > device in hard disk. Please consult your system administrator or
database
> > administrator
> > to obtain the required permissions to write in to the hard disk (Write
> > permission on the folder you craete the backup file).
> >
> > Thanks
> > Hari
> > MCDBA
> >
> > "Eric Clapton" <no_spam@.bk.com> wrote in message
> > news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> > > I have assigned an user id to a role of db_backupoperator. But after I
> > > created a scheduled job to do backup weekly, it won't run at all. No
> error
> > > message in the event application. So I go to do the backup manually.
I
> > get
> > > an error message when I click the "..." button to specify the backup
> file
> > > location as following:
> > >
> > > Microsoft SQL-DMO (ODBC SQLState: 42000)
> > >
> > > "Error 229: Execute permission denied on object 'xp_availablemedia',
> > > database 'master', owner 'dbo'."
> > >
> > > Please help. Thanks.
> > >
> > >
> >
> >
>|||Hari,
I found out that both services are started with local system
accounts. Does that mean whoever shut down and re-start the service is the
local system accounts? Or it mean something else? Do I need to re-start both
services with the user id I used to do backup?
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23601RbaMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Hi,
> The user in which you start the SQL Server and SQL Agent service should
have
> the permission.
> Thanks
> Hari
> MCDBA
>
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:uTQM2WaMEHA.2824@.TK2MSFTNGP10.phx.gbl...
> > Thanks, Hari. I have created the user id previously and didn't assign a
> > local win 2k user id to it. May be this is the problem. Now I just
> created
> > a local win 2k user id with the access right. But I don't want to delete
> the
> > sql user id and re-create it again? How can I map the current sql 2k
user
> id
> > with the local win 2k user? Please let me know. Thanks.
> >
> >
> > "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> > news:uWGed8ZMEHA.808@.tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > Its seems your login account does not have the permissions required to
> > > create a backup
> > > device in hard disk. Please consult your system administrator or
> database
> > > administrator
> > > to obtain the required permissions to write in to the hard disk (Write
> > > permission on the folder you craete the backup file).
> > >
> > > Thanks
> > > Hari
> > > MCDBA
> > >
> > > "Eric Clapton" <no_spam@.bk.com> wrote in message
> > > news:#bQGXdZMEHA.2628@.TK2MSFTNGP12.phx.gbl...
> > > > I have assigned an user id to a role of db_backupoperator. But after
I
> > > > created a scheduled job to do backup weekly, it won't run at all. No
> > error
> > > > message in the event application. So I go to do the backup
manually.
> I
> > > get
> > > > an error message when I click the "..." button to specify the backup
> > file
> > > > location as following:
> > > >
> > > > Microsoft SQL-DMO (ODBC SQLState: 42000)
> > > >
> > > > "Error 229: Execute permission denied on object 'xp_availablemedia',
> > > > database 'master', owner 'dbo'."
> > > >
> > > > Please help. Thanks.
> > > >
> > > >
> > >
> > >
> >
> >
>

db_backupoperator question

Wednesday, March 21, 2012

DB Shrink - Could not adjust the space allocation for file Error

About once a month I receive the follow error from my weekly DB Shrink job.
I have always run a DBCheck afterwards and the database is clean. I have
searched the web and MS but have been unable to find any detailed information
on this error message. Any help / comments would be greatly appreciated.
Message:
Executed as user: xDOMAIN\xxxx Could not adjust the space allocation for
file 'x_Data'. [SQLSTATE 42000] (Error 3140) DBCC execution completed. If
DBCC printed error messages, contact your system administrator. [SQLSTATE
01000] (Error 2528). The step failed.
Server:
SQL 2000 SP3a
JKLI can't help with the error, but I can still give you a bit of good
advice. Stop shrinking every week, or at any other regular interval.
Set the database size to what it needs to be so that there is no need
for automatic growth. Monitor the space and add more before it runs
out. Add enough that you will not have to add more any time soon.
Constant shrinking and growth is bad for performance. Automatic space
allocation always causes a delay. The physical files get fragmented
on the hard drive.
Roy Harvey
Beacon Falls, CT
On Thu, 1 Nov 2007 08:20:03 -0700, JKL <JKL@.discussions.microsoft.com>
wrote:
>About once a month I receive the follow error from my weekly DB Shrink job.
>I have always run a DBCheck afterwards and the database is clean. I have
>searched the web and MS but have been unable to find any detailed information
>on this error message. Any help / comments would be greatly appreciated.
>Message:
>Executed as user: xDOMAIN\xxxx Could not adjust the space allocation for
>file 'x_Data'. [SQLSTATE 42000] (Error 3140) DBCC execution completed. If
>DBCC printed error messages, contact your system administrator. [SQLSTATE
>01000] (Error 2528). The step failed.
>
>Server:
>SQL 2000 SP3a
>JKL|||DO NOT SHRINK SQL SERVER DATABASES OR LOGS!! :-)
See http://www.karaszi.com/SQLServer/info_dont_shrink.asp and search web for
other reasons not to do this.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"JKL" <JKL@.discussions.microsoft.com> wrote in message
news:3450C0F0-3622-4512-BE2D-AC338AD935FF@.microsoft.com...
> About once a month I receive the follow error from my weekly DB Shrink
> job.
> I have always run a DBCheck afterwards and the database is clean. I have
> searched the web and MS but have been unable to find any detailed
> information
> on this error message. Any help / comments would be greatly appreciated.
> Message:
> Executed as user: xDOMAIN\xxxx Could not adjust the space allocation for
> file 'x_Data'. [SQLSTATE 42000] (Error 3140) DBCC execution completed. If
> DBCC printed error messages, contact your system administrator. [SQLSTATE
> 01000] (Error 2528). The step failed.
>
> Server:
> SQL 2000 SP3a
> JKL|||Why are you running a weekly shrink operation in the first place? If it
needed to be that big last week and the week before and the week before
don't you think it will need to be that big next week and the week after?
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Not sure what this error was but have you run a disk diagnostic lately?
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"JKL" <JKL@.discussions.microsoft.com> wrote in message
news:3450C0F0-3622-4512-BE2D-AC338AD935FF@.microsoft.com...
> About once a month I receive the follow error from my weekly DB Shrink
> job.
> I have always run a DBCheck afterwards and the database is clean. I have
> searched the web and MS but have been unable to find any detailed
> information
> on this error message. Any help / comments would be greatly appreciated.
> Message:
> Executed as user: xDOMAIN\xxxx Could not adjust the space allocation for
> file 'x_Data'. [SQLSTATE 42000] (Error 3140) DBCC execution completed. If
> DBCC printed error messages, contact your system administrator. [SQLSTATE
> 01000] (Error 2528). The step failed.
>
> Server:
> SQL 2000 SP3a
> JKL

Thursday, March 8, 2012

DB Optimization

SQL 7.0
I scheduled a Optimization job to run weekly once and its taking around 5
hrs .During this time users are getting locked.
What are all the best options to handle this '
We are not able to get a continuous 5 hrs down time for application '
Thx
ShDo you mean index rebuilds?
Index rebuilds acquire locks on the table (exclusive for clustered =indexes and shared for non-clustered); they do require downtime.
SQL Server 7.0 doesn't have an online index defrag option such as the =one provided by SQL Server 2000 (DBCC INDEXDEFRAG).
-- BG, SQL Server MVP
Solid Quality Learning
www.solidqualitylearning.com
"Shamim" <shamim.abdul@.railamerica.com> wrote in message =news:OsxzOzSVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> SQL 7.0
> > I scheduled a Optimization job to run weekly once and its taking =around 5
> hrs .During this time users are getting locked.
> What are all the best options to handle this '
> > We are not able to get a continuous 5 hrs down time for application '
> > Thx
> Sh
> >|||Itzik
An alternative is to use the DBCC command SHOWCONTIG to
get an idea of the fragmentation of your files. It is very
likely that they fragment at different rates. When you get
a feel for how quickly your different tables fragment you
may be able to schedule your index rebuilds in a way that
fits into your available window.
Regards
John|||Thanks Itzik for the reply.
Just wanna know , how a production critical environment handle this issue'
Is it like, transfering application to a hot backup , optimize production db
, restore the downtime transaction log and connect back.
Thx
Sh
"Itzik Ben-Gan" <itzik@.REMOVETHIS.solidqualitylearning.com> wrote in message
news:eVN192SVDHA.1928@.TK2MSFTNGP12.phx.gbl...
Do you mean index rebuilds?
Index rebuilds acquire locks on the table (exclusive for clustered indexes
and shared for non-clustered); they do require downtime.
SQL Server 7.0 doesn't have an online index defrag option such as the one
provided by SQL Server 2000 (DBCC INDEXDEFRAG).
--
BG, SQL Server MVP
Solid Quality Learning
www.solidqualitylearning.com
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:OsxzOzSVDHA.1832@.TK2MSFTNGP09.phx.gbl...
> SQL 7.0
> I scheduled a Optimization job to run weekly once and its taking around 5
> hrs .During this time users are getting locked.
> What are all the best options to handle this '
> We are not able to get a continuous 5 hrs down time for application '
> Thx
> Sh
>

DB Optimizactions

I set up Optimization weekly:
Reorganize data and index pages, change free spaces per
page percentage to 10%,
Remove unused space from database files, shrink database
when it grows beyond 50MB, amount of free space to remain
after shrink: 10%.
The job runs normally, but I still see my TL grow to >
1GB. Then I manually ran the job, expecting to see TL
file shrunk, but it didn't happen.
Does manually running Optimization shrink TL file size?
or I have to run DBCC SHRINKDATABASE?
Thanks.Locus Adam wrote:
> I set up Optimization weekly:
> Reorganize data and index pages, change free spaces per
> page percentage to 10%,
> Remove unused space from database files, shrink database
> when it grows beyond 50MB, amount of free space to remain
> after shrink: 10%.
> The job runs normally, but I still see my TL grow to >
> 1GB. Then I manually ran the job, expecting to see TL
> file shrunk, but it didn't happen.
> Does manually running Optimization shrink TL file size?
> or I have to run DBCC SHRINKDATABASE?
> Thanks.
I've only ever managed to totally shrink a logfile by setting the db
into simple logging mode.|||Yes this will stop TL from growing, but the trade off is
that you lose full recovery in case you lost your DB.
>--Original Message--
>Locus Adam wrote:
>> I set up Optimization weekly:
>> Reorganize data and index pages, change free spaces per
>> page percentage to 10%,
>> Remove unused space from database files, shrink
database
>> when it grows beyond 50MB, amount of free space to
remain
>> after shrink: 10%.
>> The job runs normally, but I still see my TL grow to >
>> 1GB. Then I manually ran the job, expecting to see TL
>> file shrunk, but it didn't happen.
>> Does manually running Optimization shrink TL file
size?
>> or I have to run DBCC SHRINKDATABASE?
>> Thanks.
>I've only ever managed to totally shrink a logfile by
setting the db
>into simple logging mode.
>.
>|||It makes absolutely no sense to shrink the file immediately after doing a
reorg. Shriking the file will most likely destroy or undo what the reorg
just finished doing. Uncheck the box that states to shrink the file. You
need lots of free space in the database and log for them to function
normally. If you are not using SIMPLE mode you must do regular log backups
to keep the log file from growing all the time and eventually it will get to
a point where it does not need to grow. That's where you want to keep it.
--
Andrew J. Kelly
SQL Server MVP
"Locus Adam" <anonymous@.discussions.microsoft.com> wrote in message
news:844c01c3f71a$ece3ac60$7d02280a@.phx.gbl...
> I set up Optimization weekly:
> Reorganize data and index pages, change free spaces per
> page percentage to 10%,
> Remove unused space from database files, shrink database
> when it grows beyond 50MB, amount of free space to remain
> after shrink: 10%.
> The job runs normally, but I still see my TL grow to >
> 1GB. Then I manually ran the job, expecting to see TL
> file shrunk, but it didn't happen.
> Does manually running Optimization shrink TL file size?
> or I have to run DBCC SHRINKDATABASE?
> Thanks.|||Andrew is correct. However, if you have extended the log file dramatically
due to some never to be repeated operation, you can shrink just the log file
and reclaim some disk space in that case. (Otherwise, you are running a Red
Queen's Race and never getting anywhere.)
Russell Fields
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Ok9LW8x9DHA.1392@.tk2msftngp13.phx.gbl...
> It makes absolutely no sense to shrink the file immediately after doing a
> reorg. Shriking the file will most likely destroy or undo what the reorg
> just finished doing. Uncheck the box that states to shrink the file.
You
> need lots of free space in the database and log for them to function
> normally. If you are not using SIMPLE mode you must do regular log
backups
> to keep the log file from growing all the time and eventually it will get
to
> a point where it does not need to grow. That's where you want to keep it.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Locus Adam" <anonymous@.discussions.microsoft.com> wrote in message
> news:844c01c3f71a$ece3ac60$7d02280a@.phx.gbl...
> > I set up Optimization weekly:
> >
> > Reorganize data and index pages, change free spaces per
> > page percentage to 10%,
> >
> > Remove unused space from database files, shrink database
> > when it grows beyond 50MB, amount of free space to remain
> > after shrink: 10%.
> >
> > The job runs normally, but I still see my TL grow to >
> > 1GB. Then I manually ran the job, expecting to see TL
> > file shrunk, but it didn't happen.
> >
> > Does manually running Optimization shrink TL file size?
> > or I have to run DBCC SHRINKDATABASE?
> >
> > Thanks.
>

Saturday, February 25, 2012

DB Maintenance Plan optimization job aborts

My weekly SQL Server Database Maintenance Plan optimization job aborts
with the error listed below.
Please me resolve this error.
Thank You,
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
found this
http://groups-beta.google.com/group/...osoft+SQL-DMO+(ODBC+SQLState:+42000)]+Error+1934:+[Microsoft][ODBC+SQL&rnum=4#434422e74f541c1b

DB Maintenance Plan optimization job aborts

My weekly SQL Server Database Maintenance Plan optimization job aborts
with the error listed below.
Please me resolve this error.
Thank You,
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options
have
incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.found this
http://groups-beta.google.com/group...rosoft+SQL-DMO+(
ODBC+SQLState:+42000)]+Error+1934:+[Microsoft][ODBC+SQL&rnum=4#43442
2e74f541c1b

DB Maintenance Plan optimization job aborts

My weekly SQL Server Database Maintenance Plan optimization job aborts
with the error listed below.
Please me resolve this error.
Thank You,
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL
Server Driver][SQL Server]DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'.found this
http://groups-beta.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/facf07b869125687/434422e74f541c1b?lnk=st&q=[Microsoft+SQL-DMO+(ODBC+SQLState:+42000)]+Error+1934:+[Microsoft][ODBC+SQL&rnum=4#434422e74f541c1b

Friday, February 24, 2012

DB Maintenance Plan

I have a question on DB Maintenance Plan:
If we create a plan with "Reorganize Data and Index Pages"
selected only, and running the job weekly, do we also need
to set up another job to run sp_updatestats?
Thanks,
Vickyyes
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Vicky" <vickyfan@.hotmail.com> wrote in message
news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> I have a question on DB Maintenance Plan:
> If we create a plan with "Reorganize Data and Index Pages"
> selected only, and running the job weekly, do we also need
> to set up another job to run sp_updatestats?
> Thanks,
> Vicky|||That step executes DBCC DBREINDEX which does a full rebuild of the indexes.
The statistics are updated with that rebuild, so there is not need to run
UPDATE STATISTICS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vicky" <vickyfan@.hotmail.com> wrote in message
news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> I have a question on DB Maintenance Plan:
> If we create a plan with "Reorganize Data and Index Pages"
> selected only, and running the job weekly, do we also need
> to set up another job to run sp_updatestats?
> Thanks,
> Vicky|||Oops, thanks Tibor... I read too fast and though she was talking about
backing up the database, not rebuilding indexes.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e$BhynuAEHA.2480@.TK2MSFTNGP12.phx.gbl...
> That step executes DBCC DBREINDEX which does a full rebuild of the
indexes.
> The statistics are updated with that rebuild, so there is not need to run
> UPDATE STATISTICS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Vicky" <vickyfan@.hotmail.com> wrote in message
> news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> > I have a question on DB Maintenance Plan:
> >
> > If we create a plan with "Reorganize Data and Index Pages"
> > selected only, and running the job weekly, do we also need
> > to set up another job to run sp_updatestats?
> >
> > Thanks,
> >
> > Vicky
>

DB Maintenance Plan

I have a question on DB Maintenance Plan:
If we create a plan with "Reorganize Data and Index Pages"
selected only, and running the job weekly, do we also need
to set up another job to run sp_updatestats?
Thanks,
Vickyyes
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Vicky" <vickyfan@.hotmail.com> wrote in message
news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> I have a question on DB Maintenance Plan:
> If we create a plan with "Reorganize Data and Index Pages"
> selected only, and running the job weekly, do we also need
> to set up another job to run sp_updatestats?
> Thanks,
> Vicky|||That step executes DBCC DBREINDEX which does a full rebuild of the indexes.
The statistics are updated with that rebuild, so there is not need to run
UPDATE STATISTICS.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Vicky" <vickyfan@.hotmail.com> wrote in message
news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
> I have a question on DB Maintenance Plan:
> If we create a plan with "Reorganize Data and Index Pages"
> selected only, and running the job weekly, do we also need
> to set up another job to run sp_updatestats?
> Thanks,
> Vicky|||Oops, thanks Tibor... I read too fast and though she was talking about
backing up the database, not rebuilding indexes.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e$BhynuAEHA.2480@.TK2MSFTNGP12.phx.gbl...
> That step executes DBCC DBREINDEX which does a full rebuild of the
indexes.
> The statistics are updated with that rebuild, so there is not need to run
> UPDATE STATISTICS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Vicky" <vickyfan@.hotmail.com> wrote in message
> news:7a7901c402e1$a724f210$a301280a@.phx.gbl...
>

DB Maintenance

Hi All,
Are there any nightly or weekly proceeses I should be
running? How often should I run sp_updatestats on all my
DBs?
Are there any Microsoft suggested maintenance plans? If
so are they published anywhere?
Thanks,
GPHi,
You can execute the update statistics on all databases based on the time
user access is limited. In my case I am
doing update statistics daily scheduled usng the SQL Agent -- Jobs.
How often should I run sp_updatestats on all my DBs?
Depends up on the amount of Insert / Update and Delete happening in the
table. If your application makes many modifications to the data in
a particular table, update the statistics frequently to improve the
efficiency of queries
Are there any Microsoft suggested maintenance plans? If so are they
published anywhere?
Have a look in the below link;
http://www.sql-server-performance.com/statistics.asp
Thanks
Hari
MCDBA
"GeorgeP" <anonymous@.discussions.microsoft.com> wrote in message
news:19f2301c41d5b$d9bd7c80$a301280a@.phx.gbl...
> Hi All,
> Are there any nightly or weekly proceeses I should be
> running? How often should I run sp_updatestats on all my
> DBs?
> Are there any Microsoft suggested maintenance plans? If
> so are they published anywhere?
> Thanks,
> GP|||Thanks for the info!
I am sure once a week will be sufficient for my Databases.
GP

DB Maintenance

Hi All,
Are there any nightly or weekly proceeses I should be
running? How often should I run sp_updatestats on all my
DBs?
Are there any Microsoft suggested maintenance plans? If
so are they published anywhere?
Thanks,
GP
Hi,
You can execute the update statistics on all databases based on the time
user access is limited. In my case I am
doing update statistics daily scheduled usng the SQL Agent -- Jobs.
How often should I run sp_updatestats on all my DBs?
Depends up on the amount of Insert / Update and Delete happening in the
table. If your application makes many modifications to the data in
a particular table, update the statistics frequently to improve the
efficiency of queries
Are there any Microsoft suggested maintenance plans? If so are they
published anywhere?
Have a look in the below link;
http://www.sql-server-performance.com/statistics.asp
Thanks
Hari
MCDBA
"GeorgeP" <anonymous@.discussions.microsoft.com> wrote in message
news:19f2301c41d5b$d9bd7c80$a301280a@.phx.gbl...
> Hi All,
> Are there any nightly or weekly proceeses I should be
> running? How often should I run sp_updatestats on all my
> DBs?
> Are there any Microsoft suggested maintenance plans? If
> so are they published anywhere?
> Thanks,
> GP
|||Thanks for the info!
I am sure once a week will be sufficient for my Databases.
GP

DB Maintenance

Hi All,
Are there any nightly or weekly proceeses I should be
running? How often should I run sp_updatestats on all my
DBs?
Are there any Microsoft suggested maintenance plans? If
so are they published anywhere?
Thanks,
GPHi,
You can execute the update statistics on all databases based on the time
user access is limited. In my case I am
doing update statistics daily scheduled usng the SQL Agent -- Jobs.
How often should I run sp_updatestats on all my DBs?
Depends up on the amount of Insert / Update and Delete happening in the
table. If your application makes many modifications to the data in
a particular table, update the statistics frequently to improve the
efficiency of queries
Are there any Microsoft suggested maintenance plans? If so are they
published anywhere?
Have a look in the below link;
http://www.sql-server-performance.com/statistics.asp
Thanks
Hari
MCDBA
"GeorgeP" <anonymous@.discussions.microsoft.com> wrote in message
news:19f2301c41d5b$d9bd7c80$a301280a@.phx
.gbl...
> Hi All,
> Are there any nightly or weekly proceeses I should be
> running? How often should I run sp_updatestats on all my
> DBs?
> Are there any Microsoft suggested maintenance plans? If
> so are they published anywhere?
> Thanks,
> GP|||Thanks for the info!
I am sure once a week will be sufficient for my Databases.
GP

Sunday, March 25, 2012

db_backupoperator question

db_backupoperator question

db_backupoperator question

Wednesday, March 21, 2012

DB Shrink - Could not adjust the space allocation for file Error

Thursday, March 8, 2012

DB Optimization

DB Optimizactions

Saturday, February 25, 2012

DB Maintenance Plan optimization job aborts

DB Maintenance Plan optimization job aborts

DB Maintenance Plan optimization job aborts

Friday, February 24, 2012

DB Maintenance Plan

DB Maintenance Plan

DB Maintenance

DB Maintenance

DB Maintenance

DBCC CHECKDB

Blog Archive

About Me