Windows - SQL Server hash_0000198ceb7435f9fa3ee95bba2d6b9cc00ae4|hash_0000192c8abcb220bcba8628d6dc90b0c4c217|hash_0000194d64a53c1326fba763449874f7862109|hash_000019f9d60aba990b87c47b3d3d0321e074f4|hash_000019178ffaaf407fe3b846072d3d934059ae|hash_000019bffedd6d6361eb02c7231a652f9b1967|hash_000019de6b899a12b301a2760fcd0bf2d9d26e|hash_000019e38cc245d03cb7129a4e7acdf8d9ec9d|hash_000019fb05473e67b027d9a81d09703d1959e3|hash_000019d76cae9591bb82623d102b878736b986|hash_0000190e8a0810883bd44befaba2f7af2afec9|hash_000019e9e29cf2a51881d4b0c505c7bb230a77|hash_000019991b7c9fe41e1e4302fbcb027977c963|hash_000019a52b9b2e91f143d3c4a406970dde4210 Windows - SQL Server - Connections 1 150 600 on on 2 on on 0 0 1000 hash_08001930c269d7c5bff41d2fd10293d3384906 5B8257 4C 7 1 0 hash_06001919414480d6897c8731c7dc6c5310653e 1 hash_08001930c269d7c5bff41d2fd10293d3384906 5B8257 FF 4 1 0 hash_06001919414480d6897c8731c7dc6c5310653e Connections 2 hash_08001930c269d7c5bff41d2fd10293d3384906 0 FF 9 4 0 hash_06001919414480d6897c8731c7dc6c5310653e Current: 3 hash_08001930c269d7c5bff41d2fd10293d3384906 0 FF 9 1 0 hash_06001919414480d6897c8731c7dc6c5310653e Average: 4 hash_08001930c269d7c5bff41d2fd10293d3384906 0 FF 9 2 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Minimum 5 hash_08001930c269d7c5bff41d2fd10293d3384906 0 FF 9 3 0 hash_06001919414480d6897c8731c7dc6c5310653e Maximum: on 6 Data Source [mssql_conns] task_item_id hash_000019a345f1e0d833196f63424cf077ae7516|hash_000019299e683e1cfd1c7065b1ad2c783298c0|hash_000019d62d72f5bb5348361b1d6d411450a97f|hash_00001908d25aca5b4dbf391f4ce01f446a8ed9|hash_000019fcfb99683372064c893bb6f9ee691076|hash_000019e82e4444a953746c5a11939c22ae5a64 Windows - SQL Server - Buffer Cache 1 150 600 on on 2 on on 0 0 1000 percent hash_080019329d12ce95e83f2579d4fd812b1bc50a 837C04 4C 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 1 hash_080019329d12ce95e83f2579d4fd812b1bc50a 837C04 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Hit Ratio 2 hash_080019329d12ce95e83f2579d4fd812b1bc50a 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 3 hash_080019329d12ce95e83f2579d4fd812b1bc50a 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 4 hash_080019329d12ce95e83f2579d4fd812b1bc50a 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 5 Data Source [mssql_buffer_cache] task_item_id hash_000019dd71af97002c173f7a9491fb36c12327|hash_000019540ccc612529b34b4ba9c0125c931b06|hash_00001922488679e6439e43712b06a47eea0317|hash_000019bdfd5c64c1fc0bee016178fec4694b14|hash_000019f2e5efbd14ebbcccde49065e2597f978 Windows - SQL Server - Log Cache 1 150 600 on on 2 on on 0 0 1000 percent hash_080019558fe48d6f02864e00809bbc7bf8d90e AB4253 4C 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 1 hash_080019558fe48d6f02864e00809bbc7bf8d90e AB4253 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Hit Ratio 2 hash_080019558fe48d6f02864e00809bbc7bf8d90e 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 3 hash_080019558fe48d6f02864e00809bbc7bf8d90e 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 4 hash_080019558fe48d6f02864e00809bbc7bf8d90e 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 5 Data Source [mssql_log_cache] task_item_id hash_0000192dfc5b136c216ae8e86a9780e31b042a|hash_000019476ca8427eff11ea73172a9e7e58b77d|hash_0000191209b44e0ec0279c7dff9c9023a8de88|hash_00001990dd1e368620f5f2d8ac02c79fa75fed|hash_0000197621720820877ed0fac635cf8edb4bef Windows - SQL Server - Procedure Cache 1 150 600 on on 2 on on 0 0 1000 percent hash_080019b1fd1c19a0ba5363cf217e66c5f4e6ac FFBF00 4C 7 1 0 hash_06001919414480d6897c8731c7dc6c5310653e 1 hash_080019b1fd1c19a0ba5363cf217e66c5f4e6ac FFBF00 FF 4 1 0 hash_06001919414480d6897c8731c7dc6c5310653e Hit Ratio 2 hash_080019b1fd1c19a0ba5363cf217e66c5f4e6ac 0 FF 9 4 0 hash_06001919414480d6897c8731c7dc6c5310653e Current: 3 hash_080019b1fd1c19a0ba5363cf217e66c5f4e6ac 0 FF 9 1 0 hash_06001919414480d6897c8731c7dc6c5310653e Average: 4 hash_080019b1fd1c19a0ba5363cf217e66c5f4e6ac 0 FF 9 3 0 hash_06001919414480d6897c8731c7dc6c5310653e Maximum: on 5 Data Source [mssql_proc_cache] task_item_id hash_000019a1a8790a5803f767a31783e0a0d29071|hash_000019e7511ac553fa6341b3e5e84a09622eaa|hash_0000197d349afd6751be1e275259ba136e68eb|hash_000019e8a54b7b0bb5f4aa150e94687fa20c1a|hash_00001994e2593dcd34b87b619ffd6a3ff97490 Windows - SQL Server - Transactions 1 150 600 on on 2 on on 0 0 1000 transactions/sec hash_0800199a0dcf48fba874c8d90810a953beb05e 009F67 4C 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 1 hash_0800199a0dcf48fba874c8d90810a953beb05e 009F67 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Transactions 2 hash_0800199a0dcf48fba874c8d90810a953beb05e 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 3 hash_0800199a0dcf48fba874c8d90810a953beb05e 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 4 hash_0800199a0dcf48fba874c8d90810a953beb05e 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: 5 hash_0800199a0dcf48fba874c8d90810a953beb05e 0 FF 1 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Total: |sum:0:current:0:auto| on 6 Data Source [mssql_transactions] task_item_id hash_00001988099677b2eb6c64e2c971bac3b3c2f2|hash_000019731b831a842777f02984da01ffdef97e|hash_000019cf06398867cb8d1c37f5469487702e68|hash_00001983dcb196f4623e87f390da45b0c91658|hash_0000194d900ec49455fb523483585a819d0c84|hash_0000199417df2135546f6cb4d872c3e06ed2b3 Windows - SQL Server - Temp Tables 1 150 600 on on 2 on on 0 0 1000 hash_0800197103ccb6dc54c24c6bc83b8a5fd33540 002A97 4C 7 1 0 hash_06001919414480d6897c8731c7dc6c5310653e 1 hash_0800197103ccb6dc54c24c6bc83b8a5fd33540 002A97 FF 4 1 0 hash_06001919414480d6897c8731c7dc6c5310653e Active Temp Tables 2 hash_0800197103ccb6dc54c24c6bc83b8a5fd33540 0 FF 9 4 0 hash_06001919414480d6897c8731c7dc6c5310653e Current: 3 hash_0800197103ccb6dc54c24c6bc83b8a5fd33540 0 FF 9 1 0 hash_06001919414480d6897c8731c7dc6c5310653e Average: 4 hash_0800197103ccb6dc54c24c6bc83b8a5fd33540 0 FF 9 3 0 hash_06001919414480d6897c8731c7dc6c5310653e Maximum: on 5 Data Source [mssql_temp_tables] task_item_id hash_000019691e91f03f20ac2a4e06589dd282c282|hash_000019f8a1b0c5c91ccbcf0d67889d72ef7ae9|hash_0000197ffdcdbbabc31e75dee1e15e5553ce1e|hash_000019518e9826d01accf956b8049e4605500b|hash_000019c7eb106a24b1123d9be8a6c88cc44433 Windows - SQL Server - Page I/O 1 150 600 on on 2 on on 100 0 1000 IO/sec hash_080019fedfee76ecea84681c6fe35d1cc1d247 686240 FF 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Reads 1 hash_080019fedfee76ecea84681c6fe35d1cc1d247 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_080019fedfee76ecea84681c6fe35d1cc1d247 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_080019fedfee76ecea84681c6fe35d1cc1d247 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_080019fa08ea753e87e7db04e574e8663c8c92 55AD84 FF 8 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Writes 5 hash_080019fa08ea753e87e7db04e574e8663c8c92 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_080019fa08ea753e87e7db04e574e8663c8c92 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_080019fa08ea753e87e7db04e574e8663c8c92 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 0 FFD660 FF 4 1 hash_050019f1ac79f05f255c02f914c920f1038c54 hash_060019e9c43831e54eca8069317a2ce8c6f751 Total 9 0 0 FF 9 4 hash_050019f1ac79f05f255c02f914c920f1038c54 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 10 0 0 FF 9 1 hash_050019f1ac79f05f255c02f914c920f1038c54 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 11 0 0 FF 9 3 hash_050019f1ac79f05f255c02f914c920f1038c54 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 12 Data Source [mssql_page_reads] task_item_id hash_000019deef405011508043e87b8502fb64dfb8|hash_0000195016abcdea21e00db46634bad9525ce7|hash_000019c855ffcf9b8665c421903f0546512ae6|hash_0000190771ab030c18c8ae0c597b27bfc0b352 Data Source [mssql_page_writes] task_item_id hash_000019e1ee04254d39d27426b0c8f66059de2d|hash_000019d5c9766c84fbd505a290426eec1d3d6d|hash_000019c4f6addff0647f4cc481f51b73e04f6b|hash_000019bb18323638e3468e12c0e424205072ac Windows - SQL Server - Table Scans 1 150 600 on on 2 on on 0 0 1000 scans/sec hash_08001910606d3512c0117ac57096d7e756130d 00CF00 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Full Scans 1 hash_08001910606d3512c0117ac57096d7e756130d 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_08001910606d3512c0117ac57096d7e756130d 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_08001910606d3512c0117ac57096d7e756130d 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_080019b87c52e97fcdbef9bb21dff86043fafb 002A97 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Range Scans 5 hash_080019b87c52e97fcdbef9bb21dff86043fafb 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_080019b87c52e97fcdbef9bb21dff86043fafb 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_080019b87c52e97fcdbef9bb21dff86043fafb 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 hash_080019843aea77b32d42c6ad74f6bfb86b9bfb FF00FF FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Probe Scans 9 hash_080019843aea77b32d42c6ad74f6bfb86b9bfb 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 10 hash_080019843aea77b32d42c6ad74f6bfb86b9bfb 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 11 hash_080019843aea77b32d42c6ad74f6bfb86b9bfb 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 12 hash_0800199d45e94339f1716cfae4d6be42e01901 FF9900 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Index Searches 13 hash_0800199d45e94339f1716cfae4d6be42e01901 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 14 hash_0800199d45e94339f1716cfae4d6be42e01901 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 15 hash_0800199d45e94339f1716cfae4d6be42e01901 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 16 Data Source [mssql_fullscans] task_item_id hash_000019d41fe1febcdf5acfd1f47f6ceb440aeb|hash_0000196819052d2524224170ca724f7e0d3379|hash_000019b39a2cd3023dd50ab4e328de3ff95538|hash_00001998a0274bd749ed33f703c25e22ccecae Data Source [mssql_rangescans] task_item_id hash_0000196826881bdd461f66527e6be843c7cbfb|hash_00001937c3b49ec555962d6b337ddf1e6de341|hash_00001948f776c677b5bf104d83401ede515e0b|hash_000019376e09f4c84735b6faf0a8e279bbb1d0 Data Source [mssql_probescans] task_item_id hash_000019305d1339b5620fdf789c02bbda5120cf|hash_000019fb558996058ec7b93e247855fef237cf|hash_000019f9bea23cd07b8d7d783417c3beeb2d18|hash_0000190b1b43454d3eeb7901e37e2067d06b6a Data Source [mssql_index_srchs] task_item_id hash_00001901b0f13d2be28ad40a3a003dbfbabc7b|hash_0000198a18012499edf55cf034242ab37fb3b7|hash_0000198d308a29198678bda9175f1d9e06a866|hash_0000192386bc246bac58f32f37bbfb3bd75ac7 Windows - SQL Server - Memory 1 150 600 on on 2 on on 0 0 1024 bytes hash_0800192e3fed4cf2582afbbea07c5ffdbce7f5 6EA100 FF 7 1 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Target 9 hash_0800192e3fed4cf2582afbbea07c5ffdbce7f5 0 FF 9 4 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 10 hash_0800192e3fed4cf2582afbbea07c5ffdbce7f5 0 FF 9 1 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 11 hash_0800192e3fed4cf2582afbbea07c5ffdbce7f5 0 FF 9 3 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 12 hash_080019ce616c5740a14a1c2f1ea47df9300be6 311F4E FF 7 1 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Actual 13 hash_080019ce616c5740a14a1c2f1ea47df9300be6 0 FF 9 4 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 14 hash_080019ce616c5740a14a1c2f1ea47df9300be6 0 FF 9 1 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 15 hash_080019ce616c5740a14a1c2f1ea47df9300be6 0 FF 9 3 hash_050019634a23af5e78af0964e8d33b1a4ed26b hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 16 hash_08001973fdc58309a2ca33e1873dd7f893dcdc FFF200 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Ratio 17 hash_08001973fdc58309a2ca33e1873dd7f893dcdc 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 18 hash_08001973fdc58309a2ca33e1873dd7f893dcdc 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 19 hash_08001973fdc58309a2ca33e1873dd7f893dcdc 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 20 Data Source [mssql_target_memory] task_item_id hash_0000192de5b08be736f1b379c9899ed424883e|hash_0000190f79cc60853c53158c0fdf0b839adcfb|hash_000019bf43d03801679d6cfb74050df50d091f|hash_00001939300776ad88f5f760ff949a06611432 Data Source [mssql_total_memory] task_item_id hash_000019393ae925143cfebe64a697ae973c69ec|hash_000019c0d15b8deb9bb2cccfb3095ff1c45953|hash_0000190602117448c9da5fb83e92620060938c|hash_000019ab59e273cee997722a8f1fbb64d647f9 Data Source [mssql_mem_hit_ratio] task_item_id hash_00001983c97f93626853265e932f2d22d52efa|hash_000019efd664d0125f4a2c0265e49cdb5b592f|hash_00001951f2a6fe64149b4b0f9dee0aa120ffa9|hash_0000190f15916cc0d2275897e17f0d9db736ab Windows - SQL Server - Log Flushes 1 150 600 on on 2 on on 0 0 1000 flushes/sec hash_0800195e2bb4c2b2216339bfc8ecaf7f7d20c0 A150AA 4C 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 1 hash_0800195e2bb4c2b2216339bfc8ecaf7f7d20c0 A150AA FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Log Flushes 2 hash_0800195e2bb4c2b2216339bfc8ecaf7f7d20c0 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 3 hash_0800195e2bb4c2b2216339bfc8ecaf7f7d20c0 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 4 hash_0800195e2bb4c2b2216339bfc8ecaf7f7d20c0 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 5 Data Source [mssql_log_flushes] task_item_id hash_000019cc61477e242d7cfb9164d53ba96627a0|hash_000019537c8301f41382934db63552e720c601|hash_000019cb3dc52df668458b316b51235d771fb5|hash_0000194a946759f6b0166ba138f7234f266f59|hash_000019a3f811f60aee7e437a38777876e4d5f8 Windows - SQL Server - Log Flush I/O 1 150 600 on on 2 on on 0 0 1000 bytes/sec hash_0800190538b722c05913215c1a5ead109f047d CCBB00 4C 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 1 hash_0800190538b722c05913215c1a5ead109f047d CCBB00 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Bytes Flushed 2 hash_0800190538b722c05913215c1a5ead109f047d 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 3 hash_0800190538b722c05913215c1a5ead109f047d 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 4 hash_0800190538b722c05913215c1a5ead109f047d 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: 5 hash_0800190538b722c05913215c1a5ead109f047d 0 FF 1 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Total: |sum:auto:current:2:auto| on 6 Data Source [mssql_log_flush_io] task_item_id hash_0000194c02d39d0879ec0581addf95ea94d8bf|hash_0000192719f8f9ed8aaa38dc8568aa80faf346|hash_000019505dc52a4ba64d3b7e7e29fa214a3832|hash_000019328fcc04433449f301a642a79ca1dd64|hash_000019370a29f627d4d48e847319d757ccbf0f|hash_000019c8179e06ebb23384475bfe1c19632e5c Windows - SQL Server - Backup/Restore I/O 1 150 600 on on 2 on on 0 0 1000 bytes/sec hash_0800195e5cfd887a8f53eda41ac41d4e0416f3 ED5394 4C 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 1 hash_0800195e5cfd887a8f53eda41ac41d4e0416f3 ED5394 FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Bytes Flushed 2 hash_0800195e5cfd887a8f53eda41ac41d4e0416f3 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 3 hash_0800195e5cfd887a8f53eda41ac41d4e0416f3 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 4 hash_0800195e5cfd887a8f53eda41ac41d4e0416f3 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: 5 hash_0800195e5cfd887a8f53eda41ac41d4e0416f3 0 FF 1 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Total: |sum:auto:current:2:auto| on 6 Data Source [mssql_bckrst_bytes] task_item_id hash_000019b73738d5e40d005b893f8a43860a46b7|hash_000019a71c56605a4f83076aee18a3276bbd31|hash_000019477c9f73a491900a4d1b7ec2799845d7|hash_0000192c927354f6f48fb756b5befdf4d63f89|hash_000019198f822845e1ade019c74d7364c35eef|hash_0000193b3a55d804c8e5626869260784653e51 Windows - SQL Server - SQL Compilations 1 150 600 on on 2 on on 100 0 1000 compilations/sec hash_0800190f301d593515ffd51c67d7fcd07aee2a FF4105 FF 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Compilations 1 hash_0800190f301d593515ffd51c67d7fcd07aee2a 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 2 hash_0800190f301d593515ffd51c67d7fcd07aee2a 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 3 hash_0800190f301d593515ffd51c67d7fcd07aee2a 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 4 hash_08001908cbef502d8f20cfdc3207d230180485 FFAB00 FF 8 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Re-Compilations 5 hash_08001908cbef502d8f20cfdc3207d230180485 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 6 hash_08001908cbef502d8f20cfdc3207d230180485 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 7 hash_08001908cbef502d8f20cfdc3207d230180485 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 8 Data Source [mssql_comps] task_item_id hash_000019510b70875b5d20cb2ea0a8aa32a1c4b3|hash_0000197d1c6606ca5831ea96fc10a82c9b5c80|hash_000019f4ffbd12960c8c79d7af3ceffe6250d6|hash_000019f732e5ae89255d285f3167c69cf56d74 Data Source [mssql_recomps] task_item_id hash_0000196432c534b11a3877b1f52d8c7bcac763|hash_00001969e89398ad1237810fc0c35d3d0dfe47|hash_000019bed44cf18c56cf9c7877610887d7d81b|hash_000019e6bc60f4aa5129e1e8f226a859135448 Windows - SQL Server - Page Splits 1 150 600 on on 2 on on 0 0 1000 splits/sec hash_080019c145f65fdb83c4698fb021114e40d3f5 0ABFCC 4C 7 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 1 hash_080019c145f65fdb83c4698fb021114e40d3f5 0ABFCC FF 4 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Log Flushes 2 hash_080019c145f65fdb83c4698fb021114e40d3f5 0 FF 9 4 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Current: 3 hash_080019c145f65fdb83c4698fb021114e40d3f5 0 FF 9 1 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Average: 4 hash_080019c145f65fdb83c4698fb021114e40d3f5 0 FF 9 3 0 hash_060019e9c43831e54eca8069317a2ce8c6f751 Maximum: on 5 Data Source [mssql_page_splits] task_item_id hash_000019f3670e5d7822375c9093ea369dae6357|hash_00001961231a0864a45c47c61ab345df441a3f|hash_000019d019b36aa6a3dc6985bb7213f6b1ee21|hash_0000198683d26cc4aed85aca47881f568aedbb|hash_000019155147574e76d852c20b343037bfeab9 Windows - SQL Server - Connections |host_description| - SQL Server - Connections hash_030019b01a6e89c09e7f0a45816bf9ae4c7365 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_conns 0 10000 1 600 hash_070019de58e61fb2810eb964378f70f4f4e095 hash_0700199c78fc6c77b841cfa9b9735b5c6fc72e hash_0700190217f061a05e383b0c5c15bdeb2eaeb8 on hash_070019d299f87173f138fa41fce880682ab778 on hash_07001965c043754f1ec060de5866ce91b09ec4 on Windows - SQL Server - Buffer Cache |host_description| - SQL Server - Buffer Cache hash_03001906da30fb1e2d89e81c61866350abb678 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_buffer_cache 0 101 1 600 hash_070019ca716fef237558befb232822dee19f71 hash_070019a42b832680a3cc7c2f78227d9c5161a1 hash_0700195cb47aecb1be574540e24f7ac4eddecb on hash_07001955597012b875736d0484d7edeca5de0a on hash_0700192be356d4a684d2bafe4805d3719db28f on Windows - SQL Server - Log Cache |host_description| - SQL Server - Log Cache hash_03001950b7d419c7f74c9e188d0d8c8d3c88c0 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_log_cache 0 101 1 600 hash_07001905f35cb345e1a7b0ca0f8a29ddf9f370 hash_070019757d3fc09589df0bbf1adda863e72b23 on hash_07001943c167cfd60df80734ed008ed4228d1f hash_0700192adad3f36502014960194e4e11eaca8b on hash_070019f908ed1981927e33496eb1e09246fc92 on Windows - SQL Server - Procedure Cache |host_description| - SQL Server - Procedure Cache hash_0300192c9b79ef31b863f7d443c7c339d6bd77 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_proc_cache 0 101 1 600 hash_070019e9ea06ec32353a79d3fb69f589da8e9a hash_070019ef86c07211d186055f36845d72374c05 on hash_0700198ae225b417d07cd737f2376206411ef1 hash_070019fcb59970e559f632b7e3e8400f87f3ca on hash_0700190c3eba6283d9fe1e42c7b13229e31823 on Windows - SQL Server - Transactions |host_description| - SQL Server - Transactions hash_0300198fc48c177c7fd602076bd6ef0bce111e 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_transactions 0 50000 2 600 hash_0700195a80c8f43506f998f61abe4efe0cf1c7 hash_0700194d4fdb5b1885bf0d34ec6d6d4af93e4a on hash_070019c0b30ac8973bc4c5f17060c6bbe90514 hash_070019f3fd1af875644bb86a7db4309e1c3271 on hash_070019541209cb62c5a2c04f062184a75f9527 on Windows - SQL Server - Temp Tables |host_description| - SQL Server - Temp Tables hash_03001930d3faa7106a5f85a80b49db61346870 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_temp_tables 0 5000 1 600 hash_0700195ab97365e250de1ab95480d094691582 hash_0700193bc8a3dee7e89f9e5ddef90989b8bb47 on hash_070019aaa484190058ec7caa02d1b4a1e0ce5a hash_0700195d09e3ca45a9d644b713443a8b23d0da on hash_070019684fa1f18b9dac99314dbca8fc9bbde2 on Windows - SQL Server - Page I/O |host_description| - SQL Server - Page I/O hash_03001954ceb624a372c6fbfba7889799fe0605 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_page_reads 0 10000 2 600 hash_07001902e3d9b696903a2596ea0759157d59d6 mssql_page_writes 0 10000 2 600 hash_070019201e59d0364d60e76eed81e379c3dd4a hash_07001940f0ad554b8484db0eaef07eeac70e49 on hash_07001983b47e10539d99c08ba6bbba13f6af78 hash_07001936da4e8356e39cb489d14aaaf7c1b309 on hash_070019c674df8d2631ea424e711e749c787021 on Windows - SQL Server - Table Scans |host_description| - SQL Server - Table Scans hash_0300190c2566d976a19fc9a84932edc92a18b1 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_fullscans 0 50000 2 600 hash_0700194445dd0166ec370fb1f400731dda2310 mssql_index_srchs 0 200000 2 600 hash_070019507b88b7c79028cf8bfbf084025a8e69 mssql_probescans 0 200000 2 600 hash_070019d31aaea61c9b6287bf6b73699e06d24e mssql_rangescans 0 200000 2 600 hash_0700194c76ebbeec2bd110ced6db570f453053 hash_070019eeec27c6d038ea4000652ad7a699f2ec on hash_0700190b4a64633b6eb89c94e6e323d5abb285 hash_07001976582d3bb3ddd188472ed99d330a5349 on hash_070019382b1760740452a81883ad421c5cabdd on Windows - SQL Server - Memory |host_description| - SQL Server - Memory hash_0300196108feec48ae6138a141fdbd248a1f35 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_mem_hit_ratio 0 101 1 600 hash_07001914b36d8719bb150627b25c8b8108ab17 mssql_target_memory 0 200000000 1 600 hash_07001924c6342561d7c2d9375d277fff7761c0 mssql_total_memory 0 200000000 1 600 hash_070019443418d09bbb10c49994a835a8db8b10 hash_070019da7c1760281c3f40ba39f26db125becb on hash_07001979003e934cc04022aec67c9b70da064e hash_070019c0cc2d8549e44a79f6056206095b459d on hash_070019611c3c47952e6257977d560d236e7e0c on Windows - SQL Server - Log Flushes |host_description| - SQL Server - Log Flushes hash_030019297056a8fe029a8052deadba54bb4d82 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_log_flushes 0 1000 2 600 hash_070019a3952043b5d8266c80c3e7d7b7995d87 hash_0700190df1c2cc3247037b158e19ebf674360c hash_0700190ff561baeeb6453e0bb05dbc071817da on hash_0700192123f5dcaef9283b1b30b76821219f39 on hash_07001942deadb4a7beca58e816950c5dc62149 on Windows - SQL Server - Log Flush I/O |host_description| - SQL Server - Log Flush I/O hash_030019582bf5974b077dd15be07007a5912726 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_log_flush_io 0 100000000 2 600 hash_07001903d05ed2982cf73dd02903127bff2a85 hash_07001940e9af15a26ed07d75fc9d3225b65523 hash_070019bbeb7172dbb6c64166f1b5b1d4d48aac on hash_0700198dadb9423d65fc36b7a29699bc84d2e4 on hash_0700198d48ee4bf6b47c1b1ad0764911f3a515 on Windows - SQL Server - Backup/Restore I/O |host_description| - SQL Server - Backup/Restore I/O hash_030019b4bc79f562d6a8227dc69f1cf6f502e3 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_bckrst_bytes 0 0 2 600 hash_07001930ce6852ee61d4e5a4e31cefd1fbbd5c hash_0700195854b245950fdffb6a08ad653ede5412 hash_070019bae5fcb245a19a13e1d268f349172be0 on hash_07001941cb71bc7a80a6e64c4365ea4d88233e on hash_07001939adf1dcf25f191c03b48a3d3605efd8 on Windows - SQL Server - SQL Compilations |host_description| - SQL Server - SQL Compilations hash_030019f7b44a56a0bf0356e0ec0224d4b6f50d 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_comps 0 1000 2 600 hash_07001966a2e2f46b3f10965bbc55541baa8746 mssql_recomps 0 1000 2 600 hash_07001938e4f97049a629e5b9d7374607728e6e hash_07001983d1cbb93e8d2140df7c9c7ac0a49917 hash_070019046dcae6ac7e02203b434a382d2c4232 on hash_07001933900458a099159b725cbea3153ebe01 on hash_070019b97c217717cdabab8c36f8265fb84f9b on Windows - SQL Server - Page Splits |host_description| - SQL Server - Page Splits hash_030019e515a10ddc98c9e56aa91e06b7bfef59 300 on hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513|hash_150019cfe3be2a33e20978ad508f7ee4f10bb5 mssql_page_splits 0 100 2 600 hash_0700194033c94096316c3730d7bffefe8e001f hash_0700194ebe8f94a594d80b6e358518ce9a2dfe hash_070019e986d6f8cab8a151ae9425f7dd19487d on hash_0700193a90a7a6cc39910ffa161d1ce67a0e71 on hash_070019a84c4ed2464f89a173c34936d04c1d14 on Windows - SQL Server - Connections 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> connections <user> <password> Hostname hostname in hostname SQL Server Port on in port SQL Server username on in user SQL Server password on in password User Connections on out userconnections Windows - SQL Server - Buffer Cache 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> buffercache <user> <password> Buffer Cache Hit Ratio on out buffercachehitratio Hostname hostname in hostname SQL Server Port on in port SQL Server username on in user SQL Server password on in password Windows - SQL Server - Log Cache 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> logcache <user> <password> Log Cache Hit Ratio on out logcachehitratio SQL Server username on in user Hostname hostname in hostname SQL Server port on in port SQL Server password on in password Windows - SQL Server - Procedure Cache 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> proccache <user> <password> Procedure Cache Hit Ratio on out proccachehitratio SQL Server username on in user Hostname hostname in hostname SQL Server port on in port SQL Server password on in password Windows - SQL Server - Transactions 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> transactions <user> <password> Transactions on out transactions SQL Server username on in user Hostname hostname in hostname SQL Server port on in port SQL Server password on in password Windows - SQL Server - Temp Tables 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> temptables <user> <password> Temp Tables Active on out activetemptables SQL Server username on in user Hostname hostname in hostname SQL Server port on in port SQL Server password on in password Windows - SQL Server - Page I/O 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> pageio <user> <password> Page Reads on out pagereads Page Writes on out pagewrites SQL Server username on in user Hostname hostname in hostname SQL Server port on in port SQL Server password on in password Windows - SQL Server - Table Scans 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> scans <user> <password> Full Table/Index Scans on out fullscans Index-based Range Scans on out rangescans Probe Scans on out probescans Index Searches on out indexsearches SQL Server username on in user Hostname hostname in hostname SQL Server port on in port SQL Server password on in password Windows - SQL Server - Memory 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> memory <user> <password> Memory Hit Ratio on out memoryhitratio Memory Used on out totalservermemory Memory Target on out targetservermemory SQL Server username on in user Hostname hostname in hostname SQL Server port on in port SQL Server password on in password Windows - SQL Server - Log Flushes 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> logflushes <user> <password> Hostname hostname in hostname SQL Server port on in port SQL Server username on in user SQL Server password on in password Log Flushes on out logflushes Windows - SQL Server - Log Flush I/O 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> logflushtraffic <user> <password> Hostname hostname in hostname Bytes Flushed to disk on out bytesflushed SQL Server port on in port SQL Server username on in user SQL Server password on in password Windows - SQL Server - Backup/Restore I/O 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> bckrsttroughput <user> <password> Hostname hostname in hostname SQL Server port on in port SQL Server username on in user SQL Server password on in password Backup/Restore Bytes on out bckrsttroughput Windows - SQL Server - SQL Compilations 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> compilations <user> <password> Hostname hostname in hostname SQL Server Port on in port SQL Server user on in user SQL Server password on in password Query Compilations on out compliations Query Re-Compilations on out recompliations Windows - SQL Server - Page Splits 5 <path_cacti>/scripts/ss_win_mssql.php ss_win_mssql <hostname>:<port> pagesplits <user> <password> Hostname hostname in hostname SQL Server port on in port SQL Server user on in user SQL Server password on in password Page Splits on out pagesplits Daily (5 Minute Average) 0.5 1 1440 86400 1|3 Weekly (5 Minute Average) 0.5 1 8928 604800 1|3 Monthly (5 Minute Average) 0.5 1 25920 2678400 1|3 Yearly (30 Minute Average) 0.5 6 35040 31536000 1|3 Hourly (1 Minute Average) 0.5 1 500 14400 1|3 3 Year (2 Hour Average) 0.5 24 13140 94608000 1|3 Normal %8.2lf %s Exact Numbers %8.0lf Total All Data Sources 1 4 ALL_DATA_SOURCES_NODUPS Multiply by 1024 1 4 CURRENT_DATA_SOURCE 2 6 1024 3 2 3