Link to home
Start Free TrialLog in
Avatar of gihrnm
gihrnmFlag for Malaysia

asked on

How many databases can you mirror per instance?

I configured mirroring for 33 databases in an instance. Recently the mirroring failed and I found many network related errors like:

- Database mirroring connection error 4 '64(The specified network name is no longer available.)
- The Security System detected an authentication error for the server MSSQLSvc/servername:port.  The failure code from authentication protocol Kerberos was "There are currently no logon servers available to service the logon request.

Mirroring timeout for each database is either 10 or 30 seconds.
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Check whether you have max_worker_threads configured to handle your Mirroring load and do check this excellent article.

http://sqlcat.com/technicalnotes/comments/1102.aspx
Avatar of gihrnm

ASKER

can we relate the 2 errors related to resources overload? or they're just caused by network hiccups..
SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Welcome gihrnm