Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // ==UserScript==
- // @name Template Selector for SQL Monitor
- // @namespace
- // @version 1.0
- // @description Chooses templates in SQL Monitor
- // @author You
- // @match http://monitor.red-gate.com/Analysis/Graphs
- // @grant none
- // ==/UserScript==
- //
- // Replace these names and templates with your own choices (also make sure to set the @match URL above to your local installation of SQL Monitor
- //
- var analysisPageTemplates = [
- { Name: "Machine and SQL Server CPU",
- Template: {"selections":[{"dataStream":"[Cluster].[Machine].[Processors].[PercentProcessorTime]","path":[{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"254914-ntclus.lon.intensive.int","isVisible":true,"isAllSelected":false,"isAsAboveSelected":false},{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(All)","isVisible":true,"isAllSelected":true,"isAsAboveSelected":false}],"id":0},{"dataStream":"[Cluster].[SqlServer].[Process].[PercentProcessorTime]","path":[{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(As above)","isVisible":true,"isAllSelected":false,"isAsAboveSelected":true},{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(All)","isVisible":true,"isAllSelected":true,"isAsAboveSelected":false}],"id":1}],"serializedTime":"1422946613000_1422989813000","lineSelection":{"selectionId":1,"cir":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,9:SqlServer,1,4:Name,s4:ins1,7:Process,0,"}}
- },
- { Name: "User connections",
- Template: {"selections":[{"dataStream":"[Cluster].[SqlServer].[GeneralStatistics].[UserConnections]","path":[{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"254914-ntclus.lon.intensive.int","isVisible":true,"isAllSelected":false,"isAsAboveSelected":false},{"value":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,","text":"(All)","isVisible":true,"isAllSelected":true,"isAsAboveSelected":false}],"id":0}],"serializedTime":"1422946661000_1422989861000","lineSelection":{"selectionId":0,"cir":"7:Cluster,1,4:Name,s31:254914-ntclus.lon.intensive.int,9:SqlServer,1,4:Name,s4:ins1,17:GeneralStatistics,0,"}}
- }
- ];
- $(".toggle-compare").after("<select class='choose-template'><option val='-1'>(select template)</option></select>");
- for (var i in analysisPageTemplates) {
- $(".choose-template").append("<option value=" + i + ">"+analysisPageTemplates[i].Name+"</option>");
- }
- $(".choose-template").change(function() {
- var i = parseInt($(".choose-template").val());
- if (!analysisPageTemplates[i]) return;
- var template = analysisPageTemplates[i].Template;
- window.sessionStorage.setItem("AnalysisGraphState", JSON.stringify(template));
- location.reload();
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement