[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How many databases can you mirror per instance?

Posted on 2010-04-06
5
Medium Priority
?
334 Views
Last Modified: 2012-05-09
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.
0
Comment
Question by:gihrnm
  • 3
  • 2
5 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 29984707
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
0
 

Author Comment

by:gihrnm
ID: 29989885
can we relate the 2 errors related to resources overload? or they're just caused by network hiccups..
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 200 total points
ID: 29991404
>> The specified network name is no longer available.
>> There are currently no logon servers available to service the logon request.

Both errors can occur due to network connectivity issues or system not able to process requests ( load) on those servers at that particular point of time..
Is it happening regularly or rarely..
if it is happening rarely, then its definitely related to network issue.
Else you need to concentrate on the max_worker_threads to efficiently use your resources.
0
 

Accepted Solution

by:
gihrnm earned 0 total points
ID: 31729318
found out there were network errors.. thanks rrjegan for the reply
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 31778516
Welcome gihrnm
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question