Unsolved
This post is more than 5 years old
2 Posts
0
719
July 6th, 2010 13:00
SQL 2005 with 500-1000 databases
We have problem with our sql server backups. We have about 10 different sql servers and those have 500-1000 small databases on each server. Totally database size is about 20-30GB per server. Avamar SQL agent is so slow that 10 hour backup windows is not enough to backup whole server.
What is wrong because we have also sql servers with 200GB - 300GB database without any problem?
No Events found!
rpervan
266 Posts
0
July 7th, 2010 03:00
Hello saarija,
Maybe you should check the p_cache value on client side and increase it .
regards,
5uR68oOE7d12317
48 Posts
0
July 16th, 2010 06:00
Hi
Also Increase the p_cach or hash cache from the default of -8,
By default all the database runs with minimum (-5) as default, Translating that to real memory, on a 4GB SQl DB (4GB max, that's 822MB vs 514MB; a bit of a difference).
Since avtar theoretically won't use more than it needs, you could even allocate a full GB.
Thanks
Rudy
rpervan
266 Posts
0
July 19th, 2010 16:00
Hello Saarija,
Do you still have problems with SQL backup ?
please respond .
.R