应用用户与SQL Server 2008断开连接 [英] Apllication users are disconnected from SQL Server 2008

问题描述

你好，
我们在Windows Server 2003上运行sql server2008.服务器上有单个数据库.大约大小为9 GB的mdf和13 GB的.ldf文件.
用户报告的问题是，当很少有(5-10)个用户尝试访问应用程序simultaineoulsy时，他们会断开连接.
但是，当1-2个用户登录时，这不会发生.

我怎么能发现这是SQL服务器问题还是Web服务器问题?我只关心SQL Server问题.

我观察到，在129 GB磁盘空间中，只有2.3 GB是可用的.

Hello,
We have sql server 2008 running on windows server 2003. Single Database is there on server. Approx size is 9 GB of mdf & 13 GB of .ldf file.
The issue reported by users is that when few ( 5-10 ) users try to access the applciation simultaineoulsy, they get disconnected.
But this does not happen when 1-2 users are logged in apllciation.

How can I find that thsi is the SQL server Problem or a Web server problem? I am concerned about the SQL server problem only.

I observer that out of 129 GB diskspace only 2.3 GB is free. Could this be the cause of problem ?

推荐答案

我会免费监视磁盘，但是您是否检查了事件查看器? sql中有什么吗?也有在SQL日志检查它们.您的程序会遇到什么错误?他们必须得到一些错误吗?如果其他所有方法均失败，我将运行sql工具以查找发生了什么情况?总是会出现错误的用户数或用户总数是多少?

I would monitor the disk free but did you check the event viewer? is there anything on sql in it? also there are logs on sql check them as well. what errors do you program get? they must get some error? If all else fails I would run the sql tools to find out what is happening? is it always the same users or amount of users that start to get the error?

这篇关于应用用户与SQL Server 2008断开连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！