Server Performance

Question

Post reply

Server Performance

Rechana Rajan

SSCertifiable

Points: 7678
More actions
March 27, 2012 at 10:22 pm

#253197

Hi ,

Developement team is complaining that they are facing poor query performance all of a sudden . I checked for blocking & long running queries ,but not able to find anything unusual. Full backup was running on the server and that was the only job running at that point.

My question is whether full\log backup will cause performance issue?? As per my knowledge backup wont constitute any performance degradation.Please correct me if am wrong.

TIA

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Balance SSCrazy Points: 2636 More actions · Answer 1

Balance

SSCrazy

Points: 2636

March 28, 2012 at 1:41 am

#1465497

In our experience backups run seamlessly alongside other activity, clearly they are a volume read activity & will be causing write activity against the logs but if running a backup is causing significant problems I would be looking for something else not running right first.

M&M SSC-Insane Points: 21699 More actions · Answer 2

Rechana Rajan (3/27/2012)

Hi ,

Developement team is complaining that they are facing poor query performance all of a sudden . I checked for blocking & long running queries ,but not able to find anything unusual. Full backup was running on the server and that was the only job running at that point.

My question is whether full\log backup will cause performance issue?? As per my knowledge backup wont constitute any performance degradation.Please correct me if am wrong.

TIA

Did you check their queries?

The optimization jobs, statistics, execution plans etc. ?

M&M

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 3

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Rechana Rajan SSCertifiable Points: 7678 More actions · Answer 4

Rechana Rajan

SSCertifiable

Points: 7678

March 28, 2012 at 11:16 pm

#1466164

Thanks everyone for the reply.

Can anyone please clarify whether backup will cause performance degradation??

Gail Shaw SSC Guru Points: 1004494 More actions · Answer 5

It can if the IO subsystem can't handle the load of the queries plus the backups, but that's the only way it could.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 6

I have seen backups cause problems with a server, but usually only if that server is already operating right at the edge, with extremely have I/O & Memory operations. In general, no, backups don't cause problems. They're usually pretty light weight and minimal cost processes.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software