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

Dustin Lohse 1 Reputation point
2020-06-17T22:40:04.837+00:00

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

10315-capture.jpg

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,882 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426K Reputation points MVP
    2020-06-17T22:57:29.97+00:00

    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.

    0 comments