March 22, 2016 at 4:54 am
Hi All,
I have a 400 GB database running in live environment with SQL Server 2008 R2.
My question is if i run the dbcc checkdb command on that database will that affect performance and if it does what should i do please?
Also please i need to check how important is running that command as i never ran it before.
Regards
Nader
March 22, 2016 at 5:31 am
Nader
I'm sure it's all in the documentation, but here's a summary as I understand it. DBCC CHECKDB doesn't take any locks that will cause blocking of use activity. However, it is likely to be processor- and disk-intensive and therefore you should run it during a quiet period if possible. It's very important to run it regularly to check for corruption. You can either do that in-place or by restoring to another server and doing the check there.
John
March 22, 2016 at 5:36 am
John Mitchell-245523 (3/22/2016)
NaderI'm sure it's all in the documentation, but here's a summary as I understand it. DBCC CHECKDB doesn't take any locks that will cause blocking of use activity. However, it is likely to be processor- and disk-intensive and therefore you should run it during a quiet period if possible. It's very important to run it regularly to check for corruption. You can either do that in-place or by restoring to another server and doing the check there.
John
Thank you John, didnt know i could run it on backup restored somewhere else.
I think i will go with that option
Regards
Nader
March 22, 2016 at 6:32 am
Nothing is ever free. However, in most cases, the load is light enough that it only marginally interferes with normal operations. If you use backups to offload it, do some research, there are still a couple of checks you're going to want to run locally.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 22, 2016 at 7:01 am
Grant Fritchey (3/22/2016)
Nothing is ever free. However, in most cases, the load is light enough that it only marginally interferes with normal operations. If you use backups to offload it, do some research, there are still a couple of checks you're going to want to run locally.
Can you please tell me which ones i have to run locally and i will try to run over night.
Regards
Nader
March 22, 2016 at 7:08 am
There's a good article on it here. Be sure to read Paul Randals [/url]work on the subject.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply