Category Archives: MSSQL

High CPU usage query & Adding Index

CASE: Specific query is consuming up CPU resource cause CPU Spike(100% usage) when the DB hit count is increased. Type: MSSQL 2012 In such a case, mostly the query is known, so it can be solved by creating index for this query. But in emergency status, when Application Designer is absent and when the instant response is needed by DBA… Read More »

2,075 total views, 5 views today

log truncate interruption – open transaction Case: DB Type: MS SQL 2012 DB Recovery Model: Full One day, Growing DB log size is pressing the Disk space, it almost full. See the status of db files, the log file size has been increased very big though the transaction log backup task has been taking regularly. Once to handle this situation, just trying… Read More »

2,327 total views, 5 views today