Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fazle_rabbee
Yak Posting Veteran
63 Posts |
 Posted - 2009-06-28 : 08:07:49
|
| Dear all,Please tell me whether SQL Server agent causes the software make slow or not?? Please answer me asap with reason. I have got 90 gb database with 11 subscribers.Please response immediately.fazle rabbee |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-06-28 : 08:17:23
|
it is SQL Agent is just a scheduler for SQL Server. It is what is being executed that may or may not affect the performance of your database.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
fazle_rabbee
Yak Posting Veteran
63 Posts |
Posted - 2009-06-28 : 09:15:20
|
| Thanks for the mail. A sceduled scan of semantic antivirus some times run in the server which scan sql server agent process. I have found that at the time of scanning, sql server 2000 perfoermance degrades. Is it a fair cause? Please response asap cause I am in troubles with sql server performance. Thanks a lot.fazle rabbee |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-03 : 17:23:46
|
| Norton antivirus will attempt to consume 100% of available resources while scanning (disk / cpu). Schedule your scan to run during non peak hours. Typically for me disk is the limiting factor. Sending disk activity to 100% while the scan runs will effectively half the performance on your other file activity (specifically tlogs)on that device.If you have dedicated drives solely to Tlogs, I dont see a purpose in a scheduled scan of that drive. |
|
|
|
|
|
|
SQL Server Agent