Function runspblitzcache

src/runScripts.ts:78–89

()

//creating the quickrun script for blitzcache
let runspblitzcache = async () => {
    let fileName = "exec_sp_blitzcache.sql";
    console.log('Preparing sample run script.');
    const scriptText = `EXEC [dbo].[sp_BlitzCache]
    @SortOrder = 'reads',
        -- CPU, executions, xpm, recent compilations, memory grant, writes, all
    @Top = 10

    -- for more info: https://www.brentozar.com/blitzcache/
    `;
    new placeScript().placescript(fileName,scriptText);
};
export let disposable_runspblitzcache = vscode.commands.registerCommand('extension.run_sp_blitzcache',runspblitzcache);

//creating the quickrun script for blitzfirst