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

Solarwinds w3wp service, causing the CPU of SQL Server spiking high to 100%

Got an issue with Solarwinds, causing the CPU of SQL Server spiking high to 100%.

A bit troubleshooting leaded me to see the a traps related query hitting the database server harsh. The query is originated from w3wp service of IIS on Solarwinds Server.

SQL Server Activity Monitor shows that this query request is getting suspended and it keep going on, one after each other getting suspended (See screenshot) which cause the SQL Server CPU spiking high reaching to 100% and impacting other database applications on the SQL Server instance.

SQL Server - Activity Monitor.jpg

After restarting the Solarwinds services or killing the W3WP session brings down the CPU spikes but after while the issue starts reoccurring.

SQL Server is physical HP blade and it has heaps of resources. Solarwinds is VM and it also got adequate resources allocated.

Anyone experience this issue or any thoughts?

Find more posts tagged with

Accepted answers

All comments

pradiisaga

Hey, experiencing the same Issue, did you get the fix for this??

alphabits

I'm having this issue as well. About every 3 days or so.

FormerMember

If you could detail how your environment is setup we could look at what is causing this issue? It sounds like you have a shared SQL database server which in a busy SQL environment can lead to resourcing issues if your SQL instance is not configured efficiently. It might be worth monitoring your Solarwinds Orion SQL database using SAM (AppInsight) if you have enough licenses.

When was the last time you ran maintenance plans on your SQL server?

zennifer

Now, I don't want to get up on a podium, but acmtix may have hit the nail on the head!

I battled with our DBA... the first round was monitoring, the second round evolved when I virtualized. Once we both did our due diligence, we have not breached any performance issues.

AppInsight for SQL will definitely provide you some detailed information; you can turn it off (reclaim license) once you have gathered some information ( I believe that it takes 50 license from SAM to initiate, but the details are phenomenal).

You are probably going to find a fragmented database, and tables that need to be re-indexed.

Never want to assume... when I read the comment posted by acmtix I started saying yeah... yeah... that is probably it.....

Good luck!!! Please be sure to let us know what you find out in your situation.