SQL 2005 with 500-1000 databases

Question

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?

rpervan · Answer

Hello saarija, Maybe you should check the p_cache value on client side and increase it . regards,

5uR68oOE7d12317 · Answer

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 · Answer

Hello Saarija, Do you still have problems with SQL backup ? please respond . .R

Avamar

SQL 2005 with 500-1000 databases

Was this post helpful?