Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
axpax
Starting Member
1 Post |
 Posted - 2008-03-04 : 14:44:40
|
| Hi!I have a SQLServer 2005 running om a 64bit cluster. It is used to run a SharePoint 2007 portal. My problem is that the access to the database from the other servers in the farm is very slow. I made a test program in C# that creates a standard .Net sqlConnection and runs a simple query 100 times. When run on the database server it takes less than a second, but when I run it from the web frontend server it takes 30 seconds. It never fails, it's just slow. The network connection is fast when copying files etc.I see nothing out of the ordinary in the event log.Do any of you have an idea what might be the problem or know how I could try to find the problem?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-04 : 15:35:03
|
| Talk to your network admins and have them add a sniffer to the network to see where the bottleneck is.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Slow connection to SQL Server 2005