question

DustinLohse-5646 avatar image
0 Votes"
DustinLohse-5646 asked ·

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

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-supported
capture.jpg (124.5 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

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.







·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.