SEAL Watches List File Ver #1.00
Name;SQL Memory#2C Page splits#2C Users v1.1;ShortName;SQLP1;UID;6D471C990A3473A6477C2C21C8819C75;Conditions;CHAT#233BSQL Memory#2323232C Page splits#2323232C Users v1.1#23233BPARAMETER "Sql instance" SQLINSTANCE "SQLSERVER or MSSQL$NAME"#2323230D#2323230A// Default name of SQL instance is SQLSERVER#2323230D#2323230A// Name of other SQL instances is in form MSSQL$XXXX#2323230D#2323230A#2323230D#2323230Abegin_help#2323230D#2323230AThis CHAT script  monitors occupied  memory#2323232C  counts Page splits per seconds#2323232C #2323230D#2323230Anotify number of users.Basic performance parameters are monitored in template#2323230D#2323230AGeneral  performance  and  we  strongly recommend  to activate  this template #2323230D#2323230Ato complete MSSQL monitoring.#2323230D#2323230ANote : You can also  monitor  any SQL counter with  Watch condition #2323230D#2323230A"Performance counter" or you can add next CHAT script based on this #2323230D#2323230Atemplate" #2323230D#2323230Aend_help#2323230D#2323230A#2323230D#2323230A#2323230D#2323230Aset TargetMem PerformanceCounter( "\"+SQLINSTANCE+":Memory Manager\Target Server Memory (KB)" )#2323230D#2323230Aset TotalMem  PerformanceCounter( "\"+SQLINSTANCE+":Memory Manager\Total Server Memory (KB)" )#2323230D#2323230A#2323230D#2323230Aset UserCon PerformanceCounter( "\"+SQLINSTANCE+":General Statistics\User Connections" )#2323230D#2323230Aset PageSplits PerformanceCounter( "\"+SQLINSTANCE+":Access Methods\Page Splits/sec" )#2323230D#2323230A#2323230D#2323230A#2323230D#2323230Aif cmpnum( TargetMem#2323232C"#2323233E"#2323232C"."#2323232C"0" )#2323230D#2323230A  set MemUsage div( 0#2323232C"."#2323232C mul( 0#2323232C"."#2323232C"100"#2323232CTotalMem)#2323232C TargetMem )#2323230D#2323230Aelse#2323230D#2323230A  set MemUsage "-1"#2323230D#2323230Aendif#2323230D#2323230A#2323230D#2323230Asavevar TargetMem TotalMem MemUsage UserCon PageSplits#233BSUCC#233B5#233Bmin#233B#233B#233BX#233B#3BCHATVar#233BTotalMem#23233BSQL Total Memory kB#23233B#23233BUVERRF#233B#23233E#233B0#233BNUM#233B#233B#233B50000#233B#3BCHATVar#233BTargetMem#23233BSQL Target Memory kB#23233B#23233BUVERRF#233B#23233E#233B0#233BNUM#233B#233B#233B50000#233B#3BCHATVar#233BMemUsage#23233BSQL Memory Usage %#23233B#23233BUVERRF#233B#23233C#233B102#233BNUM#233B#233B#233B5#233B#3BCHATVar#233BPageSplits#23233BSQL Page splits / sec#23233B#23233BUVERRF#233B#23233C#233B250#233BNUM#233B#233B#233B20#233B#3BCHATVar#233BUserCon#23233BSQL User connections#23233B#23233BUVERRF#233B#23233C#233B300#233BNUM#233B#233B#233B3#233B#3B;NotifyUnk;0;StabTime;120;
Name;SQL Trans. and Deadlocks v1.1;ShortName;SQLP2;UID;0F7BAEE63B824299B137D2006B277B20;Conditions;CHAT#233BSQL Trans. and Deadlocks v1.1#23233BPARAMETER "Sql instance" SQLINSTANCE "SQLSERVER or MSSQL$NAME"#2323230D#2323230A// Default name of SQL instance is SQLSERVER#2323230D#2323230A// Name of other SQL instances is in form MSSQL$XXXX#2323230D#2323230A#2323230D#2323230Aset ActivTrans PerformanceCounter( "\"+SQLINSTANCE+":Databases(_Total)\Active Transactions" )#2323230D#2323230Aset DeadLocks PerformanceCounter( "\"+SQLINSTANCE+":Locks(_Total)\Number of Deadlocks/sec" )#2323230D#2323230A#2323230D#2323230A#2323230D#2323230Asavevar ActivTrans DeadLocks#233BSUCC#233B1#233Bmin#233B#233B#233B#233B#3BCHATVar#233BActivTrans#23233BSQL Active Transactions#23233B#23233BUVERRF#233B#23233C#233B1000#233BNUM#233B#233B#233B5#233B#3BCHATVar#233BDeadLocks#23233BSQL deadlocks / sec#23233B#23233BUVERRF#233B#23233C#233B10#233BNUM#233B#233B#233B#233B#3BServiceStatus#233B#233BS_R#233BMSSQLSERVER#233B#233B#233B#233B#233B#3BServiceStatus#233B#233BS_R#233BSQLBrowser#233B#233B#233B#233B#233B#3B;NotifyUnk;0;
