Discussion in 'Performance Tuning for Hardware Configurations' started by thanzeer, Apr 5, 2004.
You can use Performance Monitor, with some counters you can see backup and any program using CPU.
Also run Profiler to find if there is some queries taking CPU.
Ideally the backup of the database shoud be carried out during low activity period as it dews consume server resources. There is no saperate process for the same. It takes place in SQLServer.exe context.
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
What about memory settings of memory on SQL Server?
ANy other applications are sharing the server resources?
During the backup process run SP_WHO or SP_WHO2 and see physical disk activity for that process.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Seriously consider identifying slow running queries using Profiler and trying to tune them as much as possible. This is a big job, but it can significantly help reduce the current load on your server.
Brad M. McGehee, MVP
I'll close the post, because original was changed by user, and question was missed.
Thanzeer: If was some operational mistake, send me a mail and I'll reopen.
Separate names with a comma.