.Net Microsoft SqlClient Data Provider for SQL Server Causing 100% CPU Usage on DB Server

Question

Hi guys,

Total SQL noob here. Not sure if this is the right forum, but the connector from our web servers is causing the DB server to use 100% CPU usage. I'm unable to find any information on this program except how to download so I was going to attempt to update it. I was able to pull the reports for top CPU usage (attached) and I'm not sure where to go from here. Right now, our only resolution seems to be rebooting the web server (we have 2) causing the issue. Have you guys seen this before?

Thanks,

D

Answer 1

SQL data provider is not currently supported here on QnA. They're actively answering question in dedicated forums here.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqldataaccess

https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=adodotnetdataproviders

https://forums.asp.net/54.aspx/1?DataSource+Controls+SqlDataSource+ObjectDataSource+etc+

--please don't forget to Accept as answer if the reply is helpful--

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.