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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2010-09-30 : 23:46:52
|
| Dear Memberi have a one 100 GB database in sql2005 to active oltp. one erp application access this database.i have install a symantec anti-virus software(version 11) . after this installation their is very slow of this application.so please tell anybody facing this problem and what u can do. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-01 : 00:05:30
|
| You need to exclude a few things in the VS Console- \Program Files\Microsoft SQL Server\mssql.X- *.mdf- *.ldf- *.ndf- *.trn- *.bakDisable on access scanning too. there's more. see here: http://support.microsoft.com/kb/309422edit: i'd put that sniped thing here if i knew how Tara, lol |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-01 : 00:09:29
|
Thank you ma'am  |
|
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2010-10-01 : 05:10:54
|
| thanks replay to alli think it is good suggestion.but anyone if facing this problem and he can do .send his experience. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-01 : 11:42:22
|
| we did. it's not a guess. you need to exclude those directories and file types. |
|
|
|
|
|
|
slow performance of sql2005
It's open square bracket, the word sniped, and then closed square bracket: [ s n i p e d] (without the spaces)Tara Kizer