I want to know if there is a list of frequently performed operations on the database.
Loading
I want to know if there is a list of frequently performed operations on the database.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhishek ChadhaPosted Sep 16, 2021, 6:41 AM
sp_who2 / sys.dm_exec_requests / sp_whoisactiveSTATISTICS IO/TIMEBACKUP DATABASEsp_helpDBCC SQLPERFsys.dm_exec_query_statsESTORE DATABASERESTORE FILELISTONLYsp_spaceusedDBCC SHOW_STATISTICS