Function runspblitzlock

src/runScripts.ts:108–138

(context?: sqlops.ObjectExplorerContext)

 //creating the quickrun script for blitzlock
 let runspblitzlock = async (context?: sqlops.ObjectExplorerContext) => {
    let fileName = "exec_sp_blitzlock.sql";
    let scriptText = '';
    if (context && context.nodeInfo) {
        let scriptType = context.nodeInfo.nodeType;
        fileName = context.nodeInfo.label + '-' + fileName;
        var nodeBreakdown = context.nodeInfo.nodePath.split("/");
        let dbName = nodeBreakdown[2];
        switch (scriptType) {
            case "Database": {
                scriptText = `EXEC [dbo].[sp_BlitzLock]
                    @DatabaseName = '${dbName}',
                    @Top = 10`;
                break;
            }
            default: {
                scriptText = `EXEC [dbo].[sp_BlitzLock]
                    @Top = 10`;
                break;
            }
        }
    } else {
        scriptText = `EXEC [dbo].[sp_BlitzLock]
            @Top = 10
            --@DatabaseName = '',`;
    }
    scriptText += `
    -- for more info: https://www.brentozar.com/archive/2017/12/introducing-sp_blitzlock-troubleshooting-sql-server-deadlocks/
    `;
    new placeScript().placescript(fileName,scriptText,context);
};
export let disposable_runspblitzlock = vscode.commands.registerCommand('extension.run_sp_blitzlock',runspblitzlock);