SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
SI - Site Forums : Silicon Investor - New feature discussion
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: FJB who wrote (7092)5/15/2024 2:02:10 PM
From: SI Dmitry (code monkey)14 Recommendations

Recommended By
Andrew
EL KABONG!!!
FJB
kidl
Kirk ©

and 9 more members

  Read Replies (3) of 7352
 
Thanks, FJB.

Someone brought this to our attention on Twitter, and I investigated.

Rebooting our database and webservers did not resolve the speed issue. So I debugged the web application down to the individual SQL stored procedure level, and found the sp that was dragging down performance. I next determined that writes to a particular logging table on our server were running incredibly slow. So, I recreated the table under another name, deleted the old one, and renamed the new table back to the original name.

Problem resolved. Speeds lightning fast again.

I don't know how this happens, but once in a while, high access tables in MS SQL get corrupted in some bizarre manner that causes the server to run dog slow when writing to them. It's not very often this happens, but I've seen this problem enough in the past with other tables that I knew the exact steps of how to resolve the issue, as described.

Regards,

@Dima
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News