search

newrelic / nri-mssql

New Relic Infrastructure Mssql Integration
MIT License
9 stars 18 forks source link

include "nolock" in total disk space query #93

Closed sigilioso closed 2 years ago

sigilioso commented 2 years ago

Avoids potential deadlocks when other queries are blocking this particular table (E.g.: conflicting RESTORE LOG).

dprice-int commented 2 years ago

As the person who raised this issue, thanks @sigilioso for the fix :-). I did tell the support team that a nolock hint was the simplest solution so glad to see it implemented.