Hi , Is anyone aware of Max Connections a Microsoft SQL Server can serve .We are getting random disconnections to the SQL Database .Any resources pointed to such issue welcome . Thanks mibsun
Its available with maximum value of configured connections. Check the current activity and profiler to see the activity on the Server. And also captuer PERFMON counters for assessment such as Physical disk, user connections, memory, process, processor etc. _________ Satya SKJ Moderator SQL-Server-Performance.Com
if the option "user connections" is set to the default, then it would be 32767 per instance check using sp_configure This should not reult in disconnections though, instead it would result in an error message when attempting to log on There is nothing in the error log? no errors back to the client? nothing in the event log? No other network type issues, e.g. exchange client disconnects randomly? Cheers Twan