- 
				infused
 - Service Provider
 - Posts: 178
 - Liked: 13 times
 - Joined: Apr 20, 2013 9:25 am
 - Full Name: Hayden Kirk
 - Contact:
 
Error: SQL Server Unavailable
Seems under heavy load this error crops up on jobs. Re-running the job without heavy load and it's fine. Is there some sort of time out on the SQL queries or something?
			
			
									
						
										
						- 
				millardjk
 - Expert
 - Posts: 114
 - Liked: 25 times
 - Joined: Dec 09, 2012 3:50 am
 - Full Name: Jim Millard
 - Contact:
 
Re: Error: SQL Server Unavailable
"Timing out" is exactly the problem. I fixed it in my environment by tuning the Veeam server a little better. We started with too little memory for the core count, plus the VM wasn't configured optimally for the underlying host. We were only backing up 4 VMs, but they each had a lot of disks. By increasing the memory from 4GB to 6GB and reorganizing the 8-vCPU from "8 sockets" to "2 sockets, 4 cores" (exactly matching the hosts before HT), we boosted the working memory and the ability of SQL to multithread (SQL Express won't use multiple sockets, but it WILL use multiple cores)..
			
			
									
						
										
						- 
				infused
 - Service Provider
 - Posts: 178
 - Liked: 13 times
 - Joined: Apr 20, 2013 9:25 am
 - Full Name: Hayden Kirk
 - Contact:
 
Re: Error: SQL Server Unavailable
Thanks. Will give this a shot.
			
			
									
						
										
						Who is online
Users browsing this forum: Bing [Bot], Semrush [Bot] and 4 guests