Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SQL Server Slow Response

All,

Having struggled with my installation for a very long time, I thought it might be a good idea to take a look at what's really going on in there. Installing a sniffer with Expert module from WildPackets revealed that I have an issue with the communication towards the SQL server (which is on a different machine).

The sniffer claims that I have a bunch of these:
   SQL Server Slow Response
   Low Server-to-Client Throughput
   Busy Network or Server

I have checked the NICs and the switch that connects them, and there is nothing. NIC drivers have been upgraded etc. Now, Microsoft states that this might be a symptom of too many databases in an instance: http://support.microsoft.com/default.aspx/kb/889696

But AFAIK - there is only one database (Netperfmon)? Anyone got a clue here?

Find more posts tagged with

Accepted answers

All comments

btp

Update: when I clear web cache, and log in via web, the SQL server has 100% cpu for 30-60 sec. Seems that the initial query results in this. Logging out and back in again is swift.