Windows NT SRV-DATA 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
Apache/2.4.54 (Win64) OpenSSL/1.1.1p PHP/8.2.0
: 192.168.213.201 | : 216.73.216.87
Cant Read [ /etc/named.conf ]
8.2.0
ADMINISTRATEUR
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
[ C ]
[ E ]
[ Z ]
C: /
Program Files /
Microsoft SQL Server /
120 /
Shared /
[ HOME SHELL ]
Name
Size
Permission
Action
ErrorDumps
[ DIR ]
drwxrwxrwx
Resources
[ DIR ]
drwxrwxrwx
RsFxInstall
[ DIR ]
drwxrwxrwx
VS2008
[ DIR ]
drwxrwxrwx
en
[ DIR ]
drwxrwxrwx
fr
[ DIR ]
drwxrwxrwx
Microsoft.SqlServer.Management...
303.69
KB
-rw-rw-rw-
Microsoft.SqlServer.SqlSqmQuer...
91.69
KB
-rw-rw-rw-
Microsoft.SqlServer.Sqm.dll
87.69
KB
-rw-rw-rw-
Microsoft.SqlServer.Types.dll
382.19
KB
-rw-rw-rw-
Microsoft.SqlServer.XE.Core.dl...
65.19
KB
-rw-rw-rw-
Microsoft.SqlServer.XEvent.Lin...
278.19
KB
-rw-rw-rw-
SqlDumper.exe
117.19
KB
-rwxrwxrwx
SqlWtsn.exe
107.69
KB
-rwxrwxrwx
SqlWtsn.exe.config
329
B
-rw-rw-rw-
dbghelp.dll
1.49
MB
-rw-rw-rw-
hkengperfctr.xml
26.99
KB
-rw-rw-rw-
hkengperfctrs.dll
43.19
KB
-rw-rw-rw-
instapi120.dll
57.69
KB
-rw-rw-rw-
isacctchange.dll
25.19
KB
-rw-rw-rw-
lssyscat.dat
1.13
MB
-rw-rw-rw-
msasxpress.dll
34.69
KB
-rw-rw-rw-
msxmlsql.dll
1.33
MB
-rw-rw-rw-
sqlboot.dll
173.19
KB
-rw-rw-rw-
sqldk.dll
2.29
MB
-rw-rw-rw-
sqlftacct.dll
44.69
KB
-rw-rw-rw-
sqllang.dll
34.24
MB
-rw-rw-rw-
sqllangsvc.dll
69.19
KB
-rw-rw-rw-
sqlmgmprovider.dll
415.69
KB
-rw-rw-rw-
sqlos.dll
26.19
KB
-rw-rw-rw-
sqlsecacctchg.dll
32.69
KB
-rw-rw-rw-
sqlsqm.exe
103.69
KB
-rwxrwxrwx
sqlsvcsync.dll
319.69
KB
-rw-rw-rw-
sqltses.dll
8.56
MB
-rw-rw-rw-
sqmapi.dll
179.19
KB
-rw-rw-rw-
svrenumapi120.dll
1007.19
KB
-rw-rw-rw-
xe.dll
616.19
KB
-rw-rw-rw-
Delete
Unzip
Zip
${this.title}
Close
Code Editor : Microsoft.SqlServer.SqlSqmQueries.dll
MZ� �� � @ � � � �!�L�!This program cannot be run in DOS mode. $ PE L ��S � ! . @ ` �m @� � W @ 0 �> @ ( H .text 4� `.rsrc @ @ @.reloc @ @ B H X� � X! �� P � j"��%�%���q-���8l�5�}!� 9J깖�x�_ ƾ����ۑ`k��:���=f�5�t�/n����m �좠q��j6��\��l>��K�Rw %��,�YΥ"� �p����a�q��y�e( * ( * ( * 0 3 ~ ( , r p� ( o s � ~ *~ * � *V( rM p~ o *ri p* �� ��� � lSystem.Resources.ResourceReader, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet PADPADPH13! � S q l S q m Q u e r i e s ��<sqlsqm xmlns="http://schemas.microsoft.com/sqlserver/2008/sqmqueries"> <settings> <EnableQueriesInCode>sql</EnableQueriesInCode> </settings> <tsql cardinality="perinstance"> <CommandText> SELECT SERVERPROPERTY('Collation'), SERVERPROPERTY('EngineEdition'), SERVERPROPERTY('IsClustered'), SERVERPROPERTY('IsFullTextInstalled'), SERVERPROPERTY('IsIntegratedSecurityOnly'), SERVERPROPERTY('IsSingleUser'), CASE SERVERPROPERTY('LicenseType') WHEN 'PER_SEAT' THEN 1 WHEN 'PER_PROCESSOR' THEN 2 WHEN 'DISABLED' THEN 3 ELSE 0 END, IsNULL(SERVERPROPERTY('NumLicenses'),0), SERVERPROPERTY ('FileStreamEffectiveLevel')</CommandText> <datapoint id="466" type="STRING" /> <datapoint id="464" type="DWORD" /> <datapoint id="56" type="DWORD" /> <datapoint id="61" type="DWORD" /> <datapoint id="57" type="DWORD" /> <datapoint id="465" type="DWORD" /> <datapoint id="62" type="DWORD" /> <datapoint id="511" type="DWORD" /> <datapoint id="383" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> DECLARE @version VARCHAR(100) = CONVERT(VARCHAR(100),SERVERPROPERTY('PRODUCTVERSION')) DECLARE @ix_1st_dot INT = CHARINDEX('.',@version) DECLARE @remain_str VARCHAR(100) = SUBSTRING(@version, @ix_1st_dot+1, LEN(@version)) DECLARE @ix_2nd_dot INT = CHARINDEX('.',@remain_str) DECLARE @remain_str_2 VARCHAR(100) = SUBSTRING(@remain_str, @ix_2nd_dot+1, LEN(@remain_str)) DECLARE @ix_3rd_dot INT = CHARINDEX('.',@remain_str_2) SELECT CONVERT(INT, SUBSTRING(@version, 1, @ix_1st_dot-1)) as Major, CONVERT(INT, SUBSTRING(@remain_str, 1, @ix_2nd_dot-1)) as Minor, CONVERT(INT, SUBSTRING(@remain_str_2, 1, @ix_3rd_dot-1)) as Build </CommandText> <datapoint id="71" type="DWORD" /> <datapoint id="72" type="DWORD" /> <datapoint id="73" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> DECLARE @i bigint SET @i = (SELECT CASE WHEN occurrence = 0 THEN NULL ELSE occurrence END FROM sys.dm_exec_query_optimizer_info WHERE COUNTer = N'optimizations') SELECT MAX(CASE COUNTer WHEN N'trivial plan' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END), MAX(CASE COUNTer WHEN N'search 0' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END), MAX(CASE COUNTer WHEN N'search 1' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END), MAX(CASE COUNTer WHEN N'search 2' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END), MAX(CASE COUNTer WHEN N'timeout' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END), MAX(CASE COUNTer WHEN N'memory limit exceeded' THEN CONVERT(INT, 100000000 * (occurrence * 1.0) / @i) END), MAX(CASE COUNTer WHEN N'search 0 time' THEN CONVERT(INT, IsNull(value,0) * 10000) END), MAX(CASE COUNTer WHEN N'search 1 time' THEN CONVERT(INT, IsNull(value,0) * 10000) END), MAX(CASE COUNTer WHEN N'search 2 time' THEN CONVERT(INT, IsNull(value,0) * 10000) END), MAX(CASE COUNTer WHEN N'search 0 tasks' THEN CONVERT(INT, IsNull(value,0)) END), MAX(CASE COUNTer WHEN N'search 1 tasks' THEN CONVERT(INT, IsNull(value,0)) END), MAX(CASE COUNTer WHEN N'search 2 tasks' THEN CONVERT(INT, IsNull(value,0)) END), MAX(CASE COUNTer WHEN N'gain stage 0 to stage 1' THEN CONVERT(INT, IsNull(value,0) * 1000) END), MAX(CASE COUNTer WHEN N'gain stage 1 to stage 2' THEN CONVERT(INT, IsNull(value,0) * 1000) END) FROM sys.dm_exec_query_optimizer_info </CommandText> <datapoint id="103" type="DWORD" /> <datapoint id="104" type="DWORD" /> <datapoint id="105" type="DWORD" /> <datapoint id="106" type="DWORD" /> <datapoint id="107" type="DWORD" /> <datapoint id="108" type="DWORD" /> <datapoint id="109" type="DWORD" /> <datapoint id="110" type="DWORD" /> <datapoint id="111" type="DWORD" /> <datapoint id="112" type="DWORD" /> <datapoint id="113" type="DWORD" /> <datapoint id="114" type="DWORD" /> <datapoint id="115" type="DWORD" /> <datapoint id="116" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT COUNT(folderid) FROM msdb.dbo.sysssispackagefolders </CommandText> <datapoint id="122" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> WITH folders (folderid, parentfolderid, level) AS ( SELECT folderid, parentfolderid, 0 AS level FROM msdb.dbo.sysssispackagefolders f WHERE parentfolderid is null UNION ALL SELECT s.folderid, s.parentfolderid, level+1 FROM msdb.dbo.sysssispackagefolders s JOIN folders f on (s.parentfolderid=f.folderid)) SELECT MAX(level), CONVERT(INT,AVG(level*1.0)*100) FROM folders l WHERE NOT EXISTS (SELECT * FROM folders n WHERE l.folderid=n.parentfolderid) </CommandText> <datapoint id="123" type="DWORD" /> <datapoint id="124" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> IF EXISTS (SELECT TOP(1) * FROM msdb.sys.objects WHERE name = 'MSdistpublishers' AND type = 'U') SELECT CASE WHEN COUNT(*) > 0 THEN CONVERT(BIT,1) ELSE CONVERT(BIT,0) END FROM msdb.dbo.MSdistpublishers WHERE UPPER(publisher_type) LIKE 'ORACLE%' ELSE SELECT CONVERT(BIT,0) </CommandText> <datapoint id="126" type="BOOL" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT protocol, COUNT(*) FROM master.sys.endpoints GROUP BY protocol </CommandText> <stream id="63" numCols="2" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT DB_ID(), (SELECT COUNT(*) FROM sys.database_principals), (SELECT COUNT(*) FROM sys.dm_qn_subscriptions) </CommandText> <stream id="65" numCols="3" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT DB_ID(), (SELECT COUNT(*) FROM sys.columns), (SELECT COUNT(*) FROM sys.columns WHERE system_type_id IN(34,35,99)), (SELECT COUNT(*) FROM sys.columns WHERE system_type_id IN(165,167,231) and max_length=-1), (SELECT COUNT(*) FROM sys.columns WHERE system_type_id =241), (SELECT COUNT(*) FROM sys.columns WHERE is_filestream=1)</CommandText> <stream id="66" numCols="6" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT DB_ID(), 1, CASE WHEN COUNT(*) = 0 THEN NULL ELSE COUNT(*) END FROM sys.views v JOIN sys.indexes i ON (v.object_id=i.object_id)</CommandText> <stream id="67" numCols="3" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT DB_ID(), permission_set, COUNT(*) FROM sys.assemblies WHERE is_user_defined = 1 GROUP BY permission_set </CommandText> <stream id="68" numCols="3" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT DB_ID(), (SELECT COUNT(*) FROM sys.assemblies WHERE is_user_defined = 1), COUNT(*) FROM sys.assembly_types WHERE is_user_defined = 1 </CommandText> <stream id="69" numCols="3" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT DB_ID(), (SELECT COUNT(fulltext_catalog_id) FROM sys.fulltext_catalogs), (SELECT COUNT(distinct t.object_id) FROM sys.fulltext_indexes f JOIN sys.tables t ON (f.object_id=t.object_id) WHERE f.is_enabled=1) </CommandText> <stream id="70" numCols="3" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT packagetype, COUNT(*) FROM msdb.dbo.sysssispackages GROUP BY packagetype </CommandText> <stream id="125" numCols="2" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT CASE WHEN m.mirroring_state_desc IS NULL OR LEN(LTRIM(RTRIM(m.mirroring_state_desc))) = 0 THEN 0 ELSE 1 END, IsNULL (m.mirroring_safety_level, 0), CASE WHEN m.mirroring_witness_name IS NULL OR LEN(LTRIM(RTRIM(m.mirroring_state_desc))) = 0 THEN 0 ELSE 1 END, IsNULL (m.mirroring_role, 0), IsNULL (m.mirroring_role_sequence, 0), IsNULL (m.mirroring_safety_sequence, 0) FROM sys.databases d JOIN sys.database_mirroring m ON (d.database_id = m.database_id) WHERE name NOT IN ('pubs', 'northwind', 'HttpNorthwind', 'nwind', 'adventureworks', 'adventureworksdw') </CommandText> <stream id="252" numCols="6" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.types t JOIN sys.parameters p ON t.system_type_id = p.system_type_id AND t.user_type_id=p.user_type_id JOIN sys.objects o ON o.object_id = p.object_id WHERE is_table_type = 1</CommandText> <datapoint id="420" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns c JOIN sys.objects o on o.object_id = c.object_id WHERE o.type = 'U' AND c.system_type_id = 240 AND c.user_type_id = 128</CommandText> <datapoint id="385" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> WITH CTE AS ( SELECT DISTINCT t.object_id, c.column_id -- several indexes could be on the same column don't COUNT(*) FROM sys.indexes i JOIN sys.tables t ON t.object_id = i.object_id -- user tables only JOIN sys.index_columns ic ON ic.object_id = t.object_id AND ic.index_id = i.index_id JOIN sys.columns c on c.object_id = t.object_id AND c.column_id = ic.column_id WHERE i.type IN (1, 2) -- Clustered or Non Clustered AND c.system_type_id = 240 and c.user_type_id = 128 AND ic.is_included_column = 0) -- count key columns only SELECT COUNT(*) FROM CTE</CommandText> <datapoint id="410" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select count(*) from (select objs.object_id, idxs.index_id from sys.indexes idxs join sys.objects objs on objs.object_id = idxs.object_id join sys.index_columns icols on icols.object_id = idxs.object_id and icols.index_id = idxs.index_id join sys.columns cols on cols.object_id = icols.object_id and cols.column_id = icols.column_id where objs.type ='U' and idxs.type in (1, 2) and icols.is_included_column = 0 and (icols.index_column_id = 1 and cols.is_computed = 1 or icols.index_column_id = 2 and cols.system_type_id = 240 and cols.user_type_id = 128) and 2 = (select count(*) from sys.index_columns icols2 where icols2.object_id = idxs.object_id and icols2.index_id = idxs.index_id and icols2.is_included_column = 0) group by objs.object_id, idxs.index_id) sq</CommandText> <datapoint id="409" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(DISTINCT cols.object_id) FROM sys.foreign_key_columns fkcols JOIN sys.objects objs on objs.object_id = fkcols.parent_object_id JOIN sys.columns cols on cols.object_id = fkcols.parent_object_id and cols.column_id = fkcols.parent_column_id WHERE objs.type = 'U' -- User tables AND cols.system_type_id = 240 AND cols.user_type_id = 128 -- hierarchyID</CommandText> <datapoint id="411" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(DISTINCT cols.object_id) FROM sys.foreign_key_columns fkcols JOIN sys.objects objs on objs.object_id = fkcols.referenced_object_id JOIN sys.columns cols on cols.object_id = fkcols.referenced_object_id and cols.column_id = fkcols.referenced_column_id WHERE objs.type = 'U' -- User tables AND cols.system_type_id = 240 AND cols.user_type_id = 128</CommandText> <datapoint id="412" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns WHERE is_sparse =1</CommandText> <datapoint id="386" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.types WHERE is_table_type = 1</CommandText> <datapoint id="384" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns c JOIN sys.tables t ON t.object_id = c.object_id WHERE is_column_set = 1</CommandText> <datapoint id="395" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.indexes WHERE has_filter =1</CommandText> <datapoint id="393" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> WITH CTE AS ( SELECT DISTINCT i.object_id oid, i.index_id iid FROM sys.indexes i JOIN sys.index_columns ic ON i.object_id = ic.object_id JOIN sys.columns c ON ic.column_id = c.column_id AND c.object_id = i.object_id WHERE c.is_sparse = 1 AND ic.key_ordinal != 0 -- only key columns AND i.has_filter = 1 ) SELECT COUNT(*) FROM CTE</CommandText> <datapoint id="394" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.stats where has_filter =1 and user_created =1</CommandText> <datapoint id="389" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.columns as C join sys.types as T on C.system_type_id = T.system_type_id where T.name = 'geometry'</CommandText> <datapoint id="387" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.columns as C join sys.types as T on C.system_type_id = T.system_type_id where T.name = 'geography'</CommandText> <datapoint id="388" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.tables</CommandText> <datapoint id="390" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.indexes where object_id in (select object_id from sys.columns as C join sys.types as T on C.system_type_id = T.system_type_id where T.name = 'geometry')</CommandText> <datapoint id="408" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.indexes where object_id in (select object_id from sys.columns as C join sys.types as T on C.system_type_id = T.system_type_id where T.name = 'geography')</CommandText> <datapoint id="407" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT AVG(cells_per_object) FROM sys.spatial_index_tessellations</CommandText> <datapoint id="403" type="AVG" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.partitions WHERE data_compression_desc = 'ROW'</CommandText> <datapoint id="405" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.partitions WHERE data_compression_desc = 'PAGE'</CommandText> <datapoint id="404" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.partitions where object_id in (select object_id from sys.partitions where partition_number > 1)</CommandText> <datapoint id="415" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT CAST( ( SUM(unallocated_extent_page_COUNT) + SUM (user_object_reserved_page_COUNT) + SUM (internal_object_reserved_page_COUNT) + SUM (version_store_reserved_page_COUNT) + SUM (mixed_extent_page_COUNT) ) * 8.0 / 1024 AS int) FROM tempdb.sys.dm_db_file_space_usage</CommandText> <datapoint id="419" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> select count(*) from sys.indexes where object_id > 100 and index_id = 0</CommandText> <datapoint id="416" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.indexes where type_desc like '%COLUMNSTORE%' </CommandText> <datapoint id="689" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.indexes as i WHERE type = 1 -- CLUSTERED INDEX and object_id IN (SELECT OBJECT_ID FROM sys.tables )</CommandText> <datapoint id="392" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select count (distinct object_id + index_id) from sys.partitions where partition_number >1</CommandText> <datapoint id="414" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT COUNT(*) FROM sys.databases WHERE is_auto_create_stats_on = 1</CommandText> <datapoint id="396" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT COUNT(*) FROM sys.databases WHERE is_auto_update_stats_on = 1</CommandText> <datapoint id="398" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT COUNT(*) FROM sys.databases WHERE is_auto_update_stats_async_on = 1</CommandText> <datapoint id="397" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> select COUNT(*) from sys.columns as c join (Select * from sys.columns) as d on c.object_id = d.object_id where c.is_column_set =1 and d.is_sparse =1</CommandText> <datapoint id="391" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select latch_class, CAST (waiting_requests_count AS int), CAST (wait_time_ms AS int), CAST (max_wait_time_ms AS int) from sys.dm_os_latch_stats where waiting_requests_count > 0 or wait_time_ms > 0 or max_wait_time_ms > 0</CommandText> <stream id="475" numCols="4"> <column type="STRING" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> </stream> </tsql> <tsql cardinality="perinstance"> <CommandText> create table #OLEDBProv ( Name sysname NOT NULL, ParseName sysname NOT NULL, Description sysname NOT NULL ) insert #OLEDBProv EXECUTE master.dbo.xp_enum_oledb_providers select Name, Description from #OLEDBProv op order by [Name] ASC drop table #OLEDBProv</CommandText> <stream id="476" numCols="2"> <column type="STRING" /> <column type="STRING" /> </stream> </tsql> <tsql cardinality="perinstance"> <CommandText> select name, value_in_use from sys.configurations where name in ( 'Ad Hoc Distributed Queries', 'Ole Automation Procedures', 'remote access', 'remote admin connections', 'remote login timeout (s)', 'remote proc trans', 'remote query timeout (s)', 'access check cache quota', 'c2 audit mode', 'common criteria compliance enable', 'cross db ownership chaining', 'EKM provider enabled', 'xp_cmdshell' )</CommandText> <stream id="477" numCols="2"> <column type="STRING" /> <column type="DWORD" /> </stream> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.tables WHERE lock_escalation = 2</CommandText> <datapoint id="456" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.tables WHERE lock_escalation = 0</CommandText> <datapoint id="457" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) AS number_of_message_types FROM sys.service_message_types WHERE message_type_id > 65535</CommandText> <datapoint id="478" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (*) AS number_of_contracts FROM sys.service_contracts WHERE service_contract_id > 65535</CommandText> <datapoint id="479" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (*) AS number_of_queues FROM sys.service_queues WHERE is_ms_shipped != 1</CommandText> <datapoint id="480" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (*) AS number_of_enabled_queues FROM sys.service_queues WHERE is_ms_shipped != 1 AND is_receive_enabled = 1 AND is_enqueue_enabled = 1</CommandText> <datapoint id="481" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (*) AS number_of_activated_queues FROM sys.service_queues WHERE is_activation_enabled = 1</CommandText> <datapoint id="482" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (*) AS number_of_services FROM sys.services WHERE service_id > 65535</CommandText> <datapoint id="483" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) AS number_of_routes FROM sys.routes</CommandText> <datapoint id="484" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (DISTINCT conversation_id) AS number_of_conversations FROM sys.conversation_endpoints</CommandText> <datapoint id="485" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT COUNT(*) AS broker_enabled_databases FROM sys.databases WHERE is_broker_enabled = 1</CommandText> <datapoint id="486" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (DISTINCT conversation_id) AS number_of_encrypted_conversations FROM sys.conversation_endpoints WHERE outbound_session_key_identifier <> '00000000-0000-0000-0000-000000000000' OR inbound_session_key_identifier <> '00000000-0000-0000-0000-000000000000'</CommandText> <datapoint id="487" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT SUM(max_readers) AS number_of_queue_readers FROM sys.service_queues</CommandText> <datapoint id="488" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT COUNT(*) AS number_of_forwarders FROM sys.service_broker_endpoints WHERE is_message_forwarding_enabled = 1</CommandText> <datapoint id="489" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT (*) AS number_of_queues_with_retention FROM sys.service_queues WHERE is_retention_enabled = 1</CommandText> <datapoint id="490" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select is_enabled from sys.resource_governor_configuration</CommandText> <datapoint id="491" type="BOOL" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select case classifier_function_id when 0 then 0 else 1 end from sys.dm_resource_governor_configuration</CommandText> <datapoint id="492" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_resource_pools</CommandText> <datapoint id="493" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups</CommandText> <datapoint id="494" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_resource_pools where max_cpu_percent != 100</CommandText> <datapoint id="495" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_resource_pools where max_memory_percent != 100</CommandText> <datapoint id="496" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_resource_pools where min_cpu_percent > 0</CommandText> <datapoint id="497" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_resource_pools where min_memory_percent > 0 </CommandText> <datapoint id="498" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select SUM(min_cpu_percent) from sys.dm_resource_governor_resource_pools</CommandText> <datapoint id="499" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select SUM(min_memory_percent) from sys.dm_resource_governor_resource_pools</CommandText> <datapoint id="500" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from (select COUNT(*) as GroupCount from sys.dm_resource_governor_workload_groups group by pool_id having COUNT(*) > 1) as t where GroupCount > 1</CommandText> <datapoint id="501" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups where importance = 'HIGH'</CommandText> <datapoint id="502" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups where request_max_memory_grant_percent != 25</CommandText> <datapoint id="503" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups where request_memory_grant_timeout_sec != 0</CommandText> <datapoint id="504" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups where request_max_cpu_time_sec != 0</CommandText> <datapoint id="505" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups where group_max_requests != 0</CommandText> <datapoint id="506" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups where max_dop != 0</CommandText> <datapoint id="507" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> WITH CTE AS ( SELECT DISTINCT i.object_id oid, i.index_id iid FROM sys.indexes i JOIN sys.index_columns ic ON i.object_id = ic.object_id JOIN sys.columns c ON ic.column_id = c.column_id AND c.object_id = i.object_id WHERE c.system_type_id = 40 AND c.user_type_id = 40 -- only date columns AND ic.key_ordinal != 0 -- only key columns ) SELECT COUNT(*) FROM CTE</CommandText> <datapoint id="446" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns WHERE system_type_id = 41 AND user_type_id = 41</CommandText> <datapoint id="447" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns WHERE system_type_id = 42 AND user_type_id = 42</CommandText> <datapoint id="451" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> WITH CTE AS ( SELECT DISTINCT i.object_id oid, i.index_id iid FROM sys.indexes i JOIN sys.index_columns ic ON i.object_id = ic.object_id JOIN sys.columns c ON ic.column_id = c.column_id AND c.object_id = i.object_id WHERE c.system_type_id = 41 AND c.user_type_id = 41 -- only time columns AND ic.key_ordinal != 0 -- only key columns ) SELECT COUNT(*) FROM CTE</CommandText> <datapoint id="448" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> WITH CTE AS ( SELECT DISTINCT i.object_id oid, i.index_id iid FROM sys.indexes i JOIN sys.index_columns ic ON i.object_id = ic.object_id JOIN sys.columns c ON ic.column_id = c.column_id AND c.object_id = i.object_id WHERE c.system_type_id = 42 AND c.user_type_id = 42 -- only datetime2 columns AND ic.key_ordinal != 0 -- only key columns ) SELECT COUNT(*) FROM CTE</CommandText> <datapoint id="452" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns WHERE system_type_id = 43 AND user_type_id = 43</CommandText> <datapoint id="449" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> WITH CTE AS ( SELECT DISTINCT i.object_id oid, i.index_id iid FROM sys.indexes i JOIN sys.index_columns ic ON i.object_id = ic.object_id JOIN sys.columns c ON ic.column_id = c.column_id AND c.object_id = i.object_id WHERE c.system_type_id = 43 AND c.user_type_id = 43 -- only datetimeoffset columns AND ic.key_ordinal != 0 -- only key columns ) SELECT COUNT(*) FROM CTE</CommandText> <datapoint id="450" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns WHERE system_type_id = 40 AND user_type_id = 40</CommandText> <datapoint id="455" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT t.port, e.is_encryption_enabled, e.encryption_algorithm FROM sys.database_mirroring_endpoints e JOIN sys.tcp_endpoints t ON (e.endpoint_id = t.endpoint_id)</CommandText> <stream id="251" numCols="3" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT CONVERT(int, SUM(total_page_count * 8.0 / 1024)) FROM sys.dm_db_file_space_usage </CommandText> <datapoint id="406" type="INCREMENT"/> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.columns c JOIN sys.objects o on c.object_id=o.object_id WHERE o.type = 'U'</CommandText> <datapoint id="399" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select COUNT(*) from sys.dm_resource_governor_workload_groups where importance = 'LOW'</CommandText> <datapoint id="508" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> ; with groupsPerPool as ( select grpPerPool = COUNT(*) from sys.dm_resource_governor_workload_groups group by pool_id ) select MAX(grpPerPool) from groupsPerPool</CommandText> <datapoint id="509" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> ; with groupsPerPool as ( select grpPerPool = COUNT(*)*100 from sys.dm_resource_governor_workload_groups group by pool_id ) select AVG(grpPerPool) from groupsPerPool</CommandText> <datapoint id="510" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> select case when count(*)>0 then 1 else 0 end from sys.spatial_index_tessellations</CommandText> <datapoint id="512" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select distinct SUBSTRING(ra.clr_name, 1, CHARINDEX(',', ra.clr_name)-1) as Unsupported_FX_Assembly from sys.assemblies as a inner join sys.assembly_references as r on a.assembly_id = r.assembly_id inner join sys.assemblies as ra on r.referenced_assembly_id = ra.assembly_id where (ra.clr_name like '%publickeytoken=b03f5f7f11d50a3a,%' or ra.clr_name like '%publickeytoken=b77a5c561934e089,%') and (a.clr_name not like '%publickeytoken=b03f5f7f11d50a3a,%' and a.clr_name not like '%publickeytoken=b77a5c561934e089,%') order by Unsupported_FX_Assembly </CommandText> <stream id="531" numCols="1"> <column type="STRING" /> </stream> </tsql> <tsql cardinality="perinstance"> <CommandText> select CAST(case when value_in_use = -1 then 1 else 0 end as bit) as is_value_used_default_value , CAST(case when value_in_use = -1 then 0 else value_in_use end as int) as value_in_use from sys.configurations where name = 'cursor threshold'</CommandText> <datapoint id="530" type="BOOL" /> <datapoint id="529" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT virtual_machine_type from sys.dm_os_sys_info </CommandText> <datapoint id="559" type="dword"/> </tsql> <tsql cardinality="perinstance"> <CommandText> select count(is_encrypted)as encrypted_databases from sys.databases where is_encrypted=1 </CommandText> <datapoint id="658" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select type_desc, on_failure_desc, queue_delay from sys.server_audits </CommandText> <stream id="659" numCols="3"> <column type="STRING" /> <column type="STRING" /> <column type="DWORD" /> </stream> </tsql> <tsql cardinality="perdb"> <CommandText> select distinct audit_action_name from sys.database_audit_specification_details </CommandText> <stream id="660" numCols="1"> <column type="STRING" /> </stream> </tsql> <tsql cardinality="perinstance"> <CommandText> select distinct audit_action_name from sys.server_audit_specification_details </CommandText> <stream id="661" numCols="1"> <column type="STRING" /> </stream> </tsql> <tsql cardinality="perinstance"> <CommandText> select count(*) from sys.availability_groups </CommandText> <datapoint id="702" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select count(*) from sys.dm_hadr_database_replica_states where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) and is_local = 1 group by group_id </CommandText> <datapoint id="703" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select count(*) from sys.dm_hadr_availability_replica_states where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) group by group_id </CommandText> <datapoint id="704" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select automated_backup_preference from sys.availability_groups where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="705" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select case when (listener_id IS NOT NULL) then 1 else 0 end from sys.availability_group_listeners where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="708" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select failure_condition_level from sys.availability_groups where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="707" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select health_check_timeout from sys.availability_groups where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="706" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select availability_mode from sys.availability_replicas where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="709" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select failover_mode from sys.availability_replicas where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="710" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select primary_role_allow_connections from sys.availability_replicas where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="711" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select secondary_role_allow_connections from sys.availability_replicas where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="712" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select session_timeout from sys.availability_replicas where group_id in (select group_id from sys.dm_hadr_availability_replica_states where is_local = 1 and role = 1) </CommandText> <stream id="713" numCols="1" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT b1.device_type, ISNULL(b1.[type],'NULL') AS backup_type, b1.is_copy_only, b1.time_bucket, b1.compressed_backup_size_bucket, b1.compression_percent_bucket, b1.backup_throughput_bucket, COUNT(b1.device_type) AS 'count', b1.encryption FROM ( SELECT mf.device_type, bset.[type], CAST(bset.[is_copy_only] AS INT) AS [is_copy_only], CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 0 WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 1 AND 30 THEN 1 WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 30 AND 60 THEN 2 WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 1 AND 5 THEN 3 WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 5 AND 10 THEN 4 WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 10 AND 30 THEN 5 WHEN DATEDIFF(MINUTE, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 30 AND 60 THEN 6 WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 1 AND 2 THEN 7 WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 2 AND 6 THEN 8 WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 6 AND 12 THEN 9 WHEN DATEDIFF(HOUR, bset.[backup_start_date], bset.[backup_finish_date]) BETWEEN 12 AND 24 THEN 10 ELSE 99 END AS 'time_bucket', CASE WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 0 AND 1 THEN 0 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 1 AND 5 THEN 1 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 5 AND 25 THEN 2 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 25 AND 100 THEN 3 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 100 AND 500 THEN 4 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 500 AND 1000 THEN 5 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 1000 AND 5000 THEN 6 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 5000 AND 10000 THEN 7 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 10000 AND 50000 THEN 8 WHEN CAST(ISNULL(bset.compressed_backup_size, 0) / 1048576 AS FLOAT) BETWEEN 50000 AND 100000 THEN 9 ELSE 99 END AS compressed_backup_size_bucket, CASE WHEN CAST(((ISNULL(bset.backup_size,0) - ISNULL(bset.compressed_backup_size,0)) / CASE WHEN bset.backup_size <= 0 THEN 1 ELSE ISNULL(bset.backup_size, 1) END ) * 100 AS FLOAT) = 0.0 THEN 0 ELSE (CAST(((ISNULL(bset.backup_size,0) - ISNULL(bset.compressed_backup_size,0)) / CASE WHEN bset.backup_size <= 0 THEN 1 ELSE ISNULL(bset.backup_size, 1) END ) * 100 AS INT)/10) + 1 END AS compression_percent_bucket, CASE WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) = 0.0 THEN 0 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 0 AND 100 THEN 1 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 100 AND 500 THEN 2 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 500 AND 1000 THEN 3 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 1000 AND 5000 THEN 4 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 5000 AND 10000 THEN 5 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 10000 AND 20000 THEN 6 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 20000 AND 30000 THEN 7 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 30000 AND 50000 THEN 8 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 50000 AND 100000 THEN 9 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 100000 AND 500000 THEN 10 WHEN CAST(CAST(ISNULL(bset.compressed_backup_size, 0) / 1024 AS FLOAT) / (CASE WHEN DATEDIFF(SECOND, bset.[backup_start_date], bset.[backup_finish_date]) = 0 THEN 1 END) AS FLOAT) BETWEEN 500000 AND 1000000 THEN 11 ELSE 99 END AS backup_throughput_bucket, -- in KB CASE WHEN bset.encryptor_type like '%CERTIFICATE%' THEN 1 WHEN bset.encryptor_type like '%ASYMMETRIC KEY%' THEN 2 ELSE 0 END AS encryption FROM [msdb].[dbo].[backupset] bset WITH (READUNCOMMITTED) JOIN [msdb].[dbo].[backupmediafamily] mf WITH (READUNCOMMITTED) ON mf.media_set_id = bset.media_set_id WHERE backup_finish_date <= GETDATE() and backup_finish_date > DATEADD(hh, -24, GETDATE() ) ) AS b1 GROUP BY b1.device_type, b1.[type], b1.is_copy_only, b1.time_bucket, b1.compressed_backup_size_bucket, b1.compression_percent_bucket, b1.backup_throughput_bucket, b1.encryption </CommandText> <stream id="775" numCols="9"> <column type="DWORD" /> <column type="STRING" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> </stream> </tsql> <tsql cardinality="perdb"> <CommandText> select CAST(ISNULL(DATABASEPROPERTYEX(DB_NAME(),'CardinalityEstimationModel110'),0) as int) as IsNewCardinalityEstimationModelEnabled </CommandText> <datapoint id="714" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> select 1 as name, -- Temp DB case mf.type_desc when 'ROWS' then 1 when 'LOG' then 2 end as 'type', CAST(SUM(num_of_reads) as nvarchar(128)) as total_num_of_reads, CAST(SUM(num_of_bytes_read) as nvarchar(128)) as total_num_of_bytes_read, CAST(SUM(io_stall_read_ms) as nvarchar(128)) as total_io_stall_read_ms, CAST(SUM(num_of_writes) as nvarchar(128)) as total_num_of_writes, CAST(SUM(num_of_bytes_written) as nvarchar(128)) as total_num_of_bytes_written, CAST(SUM(io_stall_write_ms) as nvarchar(128)) as total_io_stall_write_ms, Count(*) as total from sys.dm_io_virtual_file_stats(NULL, NULL) fs, sys.master_files mf where fs.database_id = mf.database_id and fs.file_id = mf.file_id and fs.database_id = 2 and (fs.num_of_reads != 0 OR fs.num_of_writes != 0) group by mf.name, mf.type, mf.type_desc UNION ALL select 2 as name, -- User DBs case mf.type_desc when 'ROWS' then 1 when 'LOG' then 2 end as 'type', CAST(SUM(num_of_reads) as nvarchar(128)) as total_num_of_reads, CAST(SUM(num_of_bytes_read) as nvarchar(128)) as total_num_of_bytes_read, CAST(SUM(io_stall_read_ms) as nvarchar(128)) as total_io_stall_read_ms, CAST(SUM(num_of_writes) as nvarchar(128)) as total_num_of_writes, CAST(SUM(num_of_bytes_written) as nvarchar(128)) as total_num_of_bytes_written, CAST(SUM(io_stall_write_ms) as nvarchar(128)) as total_io_stall_write_ms, Count(*) as total from sys.dm_io_virtual_file_stats(NULL, NULL) fs, sys.master_files mf where fs.database_id = mf.database_id and fs.file_id = mf.file_id and fs.database_id > 4 and (fs.num_of_reads != 0 OR fs.num_of_writes != 0) group by mf.type, mf.type_desc UNION ALL select 3 as name, -- System DBs case mf.type_desc when 'ROWS' then 1 when 'LOG' then 2 end as 'type', CAST(SUM(num_of_reads) as nvarchar(128)) as total_num_of_reads, CAST(SUM(num_of_bytes_read) as nvarchar(128)) as total_num_of_bytes_read, CAST(SUM(io_stall_read_ms) as nvarchar(128)) as total_io_stall_read_ms, CAST(SUM(num_of_writes) as nvarchar(128)) as total_num_of_writes, CAST(SUM(num_of_bytes_written) as nvarchar(128)) as total_num_of_bytes_written, CAST(SUM(io_stall_write_ms) as nvarchar(128)) as total_io_stall_write_ms, Count(*) as total from sys.dm_io_virtual_file_stats(NULL, NULL) fs, sys.master_files mf where fs.database_id = mf.database_id and fs.file_id = mf.file_id and (fs.database_id = 1 OR fs.database_id = 3 OR fs.database_id = 4) and (fs.num_of_reads != 0 OR fs.num_of_writes != 0) group by mf.type, mf.type_desc </CommandText> <stream id="819" numCols="9"> <column type="DWORD" /> <column type="DWORD" /> <column type="STRING" /> <column type="STRING" /> <column type="STRING" /> <column type="STRING" /> <column type="STRING" /> <column type="STRING" /> <column type="DWORD" /> </stream> </tsql> <tsql cardinality="perinstance"> <CommandText> select case wait_type when 'PAGEIOLATCH_SH' then 1 when 'PAGEIOLATCH_UP' then 2 when 'PAGEIOLATCH_EX' then 3 when 'ASYNC_NETWORK_IO' then 4 when 'WRITELOG' then 5 else 6 end, cast(waiting_tasks_count as nvarchar(128)), cast(wait_time_ms/waiting_tasks_count as nvarchar(128)) as avg_wait_time_ms, cast(max_wait_time_ms as nvarchar(128)) from sys.dm_os_wait_stats where (wait_type = 'ASYNC_NETWORK_IO' OR wait_type like 'PAGEIOLATCH_%' OR wait_type like 'WRITELOG') and waiting_tasks_count != 0 </CommandText> <stream id="800" numCols="4"> <column type="DWORD" /> <column type="STRING" /> <column type="STRING" /> <column type="STRING" /> </stream> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.data_spaces WHERE type='FX' </CommandText> <datapoint id="804" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT CASE WHEN sum(allocated_bytes)/1024 > 2147483647 THEN 2147483647 ELSE CAST(ISNULL(sum(allocated_bytes)/1024,0) AS INT) END AS total_memory_allocated_for_system_kb FROM sys.dm_xtp_system_memory_consumers </CommandText> <datapoint id="805" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT CASE WHEN sum(memory_allocated_for_table_kb+memory_allocated_for_indexes_kb) > 2147483647 THEN 2147483647 ELSE CAST(ISNULL(sum(memory_allocated_for_table_kb+memory_allocated_for_indexes_kb) ,0) AS INT) END AS total_memory_allocated_for_user_data_kb FROM sys.dm_db_xtp_table_memory_stats </CommandText> <datapoint id="806" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT CASE WHEN SUM(memory_used_by_table_kb) > 2147483647 THEN 2147483647 ELSE CAST(ISNULL(SUM(memory_used_by_table_kb),0) AS INT) END AS total_memory_used_by_tables_kb, CASE WHEN SUM(memory_used_by_indexes_kb) > 2147483647 THEN 2147483647 ELSE CAST(ISNULL(SUM(memory_used_by_indexes_kb),0) AS INT) END AS total_memory_used_by_indexes_kb FROM sys.dm_db_xtp_table_memory_stats </CommandText> <datapoint id="807" type="INCREMENT" /> <datapoint id="808" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.dm_db_xtp_checkpoint_files </CommandText> <datapoint id="809" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.tables WHERE is_memory_optimized=1 </CommandText> <datapoint id="810" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.tables WHERE is_memory_optimized=1 AND durability=1 </CommandText> <datapoint id="811" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.sql_modules m JOIN sys.procedures p ON m.object_id=p.object_id WHERE uses_native_compilation=1 </CommandText> <datapoint id="812" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT COUNT(*) FROM sys.table_types WHERE is_memory_optimized=1 </CommandText> <datapoint id="813" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT ISNULL(AVG(c),0),ISNULL(MAX(c),0) FROM (SELECT COUNT(*) AS c FROM sys.indexes i JOIN sys.tables t ON i.object_id=t.object_id WHERE t.is_memory_optimized=1 GROUP BY i.object_id) a </CommandText> <datapoint id="814" type="MAX" /> <datapoint id="815" type="MAX" /> </tsql> <tsql cardinality="perinstance"> <CommandText> SELECT CASE WHEN total_count > 2147483647 THEN 2147483647 ELSE CAST(total_count AS INT) END AS total_count, CASE WHEN rows_touched > 2147483647 THEN 2147483647 ELSE CAST(rows_touched AS INT) END AS rows_touched, CASE WHEN dependencies_taken > 2147483647 THEN 2147483647 ELSE CAST(dependencies_taken AS INT) END AS dependencies_taken, CASE WHEN dependencies_failed > 2147483647 THEN 2147483647 ELSE CAST(dependencies_failed AS INT) END AS dependencies_failed, CASE WHEN validation_failures > 2147483647 THEN 2147483647 ELSE CAST(validation_failures AS INT) END AS validation_failures FROM sys.dm_xtp_transaction_stats </CommandText> <stream id="816" numCols="5"> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> <column type="DWORD" /> </stream> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT CASE WHEN SUM(row_update_attempts)+SUM(row_delete_attempts) > 2147483647 THEN 2147483647 ELSE CAST(ISNULL(SUM(row_update_attempts)+SUM(row_delete_attempts),0) AS INT) END AS rows_touched, CASE WHEN SUM(write_conflicts) > 2147483647 THEN 2147483647 ELSE CAST(ISNULL(SUM(write_conflicts),0) AS INT) END AS write_conflicts FROM sys.dm_db_xtp_object_stats </CommandText> <datapoint id="817" type="INCREMENT" /> <datapoint id="818" type="INCREMENT" /> </tsql> <tsql cardinality="perinstance"> <CommandText> -- smart_backup -Data point #1 - Smart Admin configured or not IF EXISTS (SELECT db_name FROM msdb.smart_admin.fn_backup_db_config(NULL)) BEGIN SELECT CONVERT(BIT, 1) AS smart_admin_configured END ELSE BEGIN SELECT CONVERT(BIT, 0) AS smart_admin_configured END </CommandText> <datapoint id="820" type="BOOL" /> </tsql> <tsql cardinality="perinstance"> <CommandText> -- -smart_backup Data point #2 - Default configuration at instance level SELECT CASE WHEN (ISNULL(credential_name, 0) IS NULL OR LTRIM(RTRIM(credential_name)) = '' ) THEN CONVERT(BIT, 0) ELSE CONVERT(BIT, 1) END AS credential_name_configured, retention_days, is_managed_backup_enabled FROM msdb.smart_admin.fn_backup_instance_config() </CommandText> <datapoint id="821" type="BOOL" /> <datapoint id="822" type="DWORD" /> <datapoint id="823" type="BOOL" /> </tsql> <tsql cardinality="perinstance"> <CommandText> -- smart_backup - Datapoint 3 - count of enabled db SELECT COUNT(db_name) AS smart_backup_enabled_db_count FROM msdb.smart_admin.fn_backup_db_config(NULL) WHERE db_name IS NOT NULL AND is_managed_backup_enabled = 1 </CommandText> <datapoint id="824" type="DWORD" /> </tsql> <tsql cardinality="perinstance"> <CommandText> -- SQLXI datapoint - count of db files in XI path SELECT COUNT(name) AS xi_db_file_count FROM sys.master_files WHERE credential_id IS NOT NULL AND state = 0 </CommandText> <datapoint id="847" type="DWORD" /> </tsql> <tsql cardinality="perdb"> <CommandText> SELECT ISNULL(AVG(c),0),ISNULL(MAX(c),0) FROM (SELECT COUNT(*) AS c FROM sys.indexes i JOIN sys.tables t ON i.object_id=t.object_id WHERE t.is_memory_optimized=1 and i.type=7 GROUP BY i.object_id) a </CommandText> <datapoint id="849" type="MAX" /> <datapoint id="850" type="MAX" /> </tsql> <tsql cardinality="perdb"> <CommandText> select count(*), CASE WHEN isnull(sum(rp.max_memory_kb), 0) > 2147483647 THEN 2147483647 ELSE cast(isnull(sum(rp.max_memory_kb), 0) as int) end as max_memory_kb, isnull(sum(rp.max_memory_percent), 0) from sys.databases d join sys.dm_resource_governor_resource_pools rp on d.resource_pool_id=rp.pool_id where database_id=db_id() and isnull(resource_pool_id, 2) > 2 and exists (select * from sys.data_spaces where type='FX') </CommandText> <datapoint id="851" type="INCREMENT" /> <datapoint id="852" type="INCREMENT" /> <datapoint id="853" type="INCREMENT" /> </tsql> <tsql cardinality="perdb"> <CommandText> select count(*), isnull(sum(ar.availability_mode-1), 0) from sys.databases d join sys.availability_replicas ar on d.group_database_id=ar.group_id and d.replica_id=ar.replica_id where database_id=db_id() and exists (select * from sys.data_spaces where type='FX') </CommandText> <datapoint id="854" type="INCREMENT" /> <datapoint id="855" type="INCREMENT" /> </tsql> </sqlsqm> BSJB v2.0.50727 l � #~ < � #Strings � � #US X #GUID h h #Blob W � �3 " � � � � � � ]> �q �q �q �q �q q ,q Eq `q {q ��? � �� � fN }� �� �� �� �q $ = 0 ? [ ? � e � V�H8 V�VL V�cL V�pL V�}L V��8 V��8 V��8 V��8 V��8 V�8 V�*8 V�@8 V�]8 V�v8 V��8 V��8 V��8 V��8 V��8 V��8 V�8 V�8 V�-8 V�C�V�U�V�q8 V��8 V��8 V��8 V��8 V��8 � �� � �� � �� � � '! �(# .! �4( 6! �� L! � 8! � �) � �1 � �9 � �A � �I � �Q � �Y � �a � �i � �q � �y � �� � �� � � � � v� � � � ��� ��� �� � � �� � � ; O T Y T ^ $ g ( � , * 0 I 4 * 8 | < | @ � D � H � L � P � T % X r \ � ` � d � h ; l � p T t � x � | � � � � � � �. + @. 3 [. s H. C �. k ?. �. # . ; �. �. K �. S �. [ . c �I � �c � �c � |c � �i � �� � � . @3 � # � �, y � R <Module> Microsoft.SqlServer.SqlSqmQueries.dll ResourcesProxy Microsoft.SqlServer.SqlSqm2 Resources AssemblyVersionInfo mscorlib System Object get_SqlSqmQueries .ctor SqlSqmQueries System.Resources ResourceManager resourceMan System.Globalization CultureInfo resourceCulture get_ResourceManager get_Culture set_Culture Culture VersionString MajorVersion MinorVersion BuildVersion SPLevel ProductVersionString ProductNameString SqlEngineUsageMetricsRoleGuidString ProductNameBrandingString LongProductNameBrandingString ProductNameShortcutBrandingString VersionLocationString ProductVersionLocationString VersionHelpKeywordPrefix VersionHelpSettingsToken SetupSupportFolder ProductLicenseFile ProductUpdateCategory SqlProductFamilyCode ProductDiscoveryId SqlInstanceIDPrefix AsInstanceIDPrefix RsInstanceIDPrefix MaxMaintenanceVersion evalTimeBombValue currentReleaseTimeBombValue WerEventNameSetupMsi WerEventNameSetupConfig ASUsageMetricsRoleGuidString VersionBIDSHelpNamespace VisualStudio2012ShellVersion VisualStudioShellVersion get_VersionHelpNamespace VersionHelpNamespace value System.Runtime.InteropServices ComVisibleAttribute System.Reflection AssemblyVersionAttribute AssemblyProductAttribute AssemblyCopyrightAttribute AssemblyCompanyAttribute AssemblyFileVersionAttribute AssemblyInformationalVersionAttribute AssemblyKeyFileAttribute AssemblyDelaySignAttribute AssemblyTrademarkAttribute AssemblyDescriptionAttribute System.Diagnostics DebuggableAttribute DebuggingModes System.Runtime.CompilerServices CompilationRelaxationsAttribute RuntimeCompatibilityAttribute Microsoft.SqlServer.SqlSqmQueries System.CodeDom.Compiler GeneratedCodeAttribute DebuggerNonUserCodeAttribute CompilerGeneratedAttribute ReferenceEquals Type RuntimeTypeHandle GetTypeFromHandle Assembly get_Assembly GetString System.ComponentModel EditorBrowsableAttribute EditorBrowsableState Microsoft.SqlServer.SqlSqm2.Resources.resources KM i c r o s o f t . S q l S e r v e r . S q l S q m 2 . R e s o u r c e s S q l S q m Q u e r i e s -m s - h e l p : / / M S . S Q L C C . v 1 2 ��/�>�D�r-Q�Z �z\V4� 1 2 . 0 . 0 . 0 � 1 2 . 0 (M i c r o s o f t S Q L S e r v e r ��{ 0 x b d 7 f 7 c 0 d , 0 x 7 c 3 6 , 0 x 4 7 2 1 , { 0 x a f , 0 x a 8 , 0 x b , 0 x a 7 , 0 x 0 , 0 x e 2 , 0 x 6 d , 0 x 9 e } } S Q L S e r v e r 2 0 1 4 2M i c r o s o f t S Q L S e r v e r 2 0 1 4 1 2 0 s q l 1 2 2S Q L S e r v e r B o o k s O n l i n e . 1 2 . 0 S Q L S e r v e r 2 0 1 4 H8 9 2 C 0 5 8 4 - 8 B 0 3 - 4 2 8 f - 9 A 7 4 - 2 2 4 F C D 6 8 8 7 C 0 L{ C B 0 E 3 2 2 F - 7 0 1 B - 4 5 6 C - A 8 0 2 - 3 9 0 6 A 1 C 5 D 7 4 C } S Q L 2 0 1 4 M S S Q L 1 2 M S A S 1 2 M S R S 1 2 � S Q L 1 2 0 M S I S Q L 1 2 0 E x c e p t i o n ��{ 0 x 2 4 1 4 b c 1 b , 0 x 1 5 7 2 , 0 x 4 c d 9 , { 0 x 9 c , 0 x a 5 , 0 x 6 5 , 0 x 1 6 , 0 x 6 d , 0 x 8 d , 0 x e f , 0 x 3 d } } *m s - h e l p : / / M S . V S C C . v 9 0 1 1 . 0 1 0 . 0 A �� $ � � $ RSA1 ''6�n_�����1�:�fl/��y�����2}/��R4H�<=\]��Ǽ��(k,Q�\�$+�Au2����I���RmRo� ���{���l�O���1 �ˢ�#V{-��P���b�왹J�|};(��� @ 3System.Resources.Tools.StronglyTypedResourceBuilder2.0.0.0 Y] a a i Microsoft SQL Server ) $Microsoft Corp. All rights reserved. Microsoft Corporation + &12.0.2000.8 ((SQL14_RTM).140220-1924 ) 12.0.2000.8 5 0e:\sql12_main_t\\sql\Common\SNK\SQL2003SNKEY.snk M HMicrosoft SQL Server is a registered trademark of Microsoft Corporation. " Sql Server SQM Queries Module TWrapNonExceptionThrows ��S > D D RSDS#���X9I���� Microsoft.SqlServer.SqlSqmQueries.pdb � _CorDllMain mscoree.dll �% @ � 0 � H X � �4 V S _ V E R S I O N _ I N F O �� � �? D V a r F i l e I n f o $ T r a n s l a t i o n �H S t r i n g F i l e I n f o $ 0 0 0 0 0 4 b 0 T C o m m e n t s S q l S e r v e r S Q M Q u e r i e s M o d u l e L C o m p a n y N a m e M i c r o s o f t C o r p o r a t i o n , F i l e D e s c r i p t i o n p ' F i l e V e r s i o n 1 2 . 0 . 2 0 0 0 . 8 ( ( S Q L 1 4 _ R T M ) . 1 4 0 2 2 0 - 1 9 2 4 ) l & I n t e r n a l N a m e M i c r o s o f t . S q l S e r v e r . S q l S q m Q u e r i e s . d l l p % L e g a l C o p y r i g h t M i c r o s o f t C o r p . A l l r i g h t s r e s e r v e d . � I L e g a l T r a d e m a r k s M i c r o s o f t S Q L S e r v e r i s a r e g i s t e r e d t r a d e m a r k o f M i c r o s o f t C o r p o r a t i o n . t & O r i g i n a l F i l e n a m e M i c r o s o f t . S q l S e r v e r . S q l S q m Q u e r i e s . d l l L P r o d u c t N a m e M i c r o s o f t S Q L S e r v e r < P r o d u c t V e r s i o n 1 2 . 0 . 2 0 0 0 . 8 < A s s e m b l y V e r s i o n 1 2 . 0 . 0 . 0 02 �> 0�>� *�H�� ��>�0�>�1 0 + 0L +�7�>0<0 +�70 ��� 0!0 + `�O�� �9j��3��dF8Ơ��0��0���3 3�'��J*� 30 *�H�� 0w1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1!0 UMicrosoft Time-Stamp PCA0 130327200823Z 140627200823Z0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1 0 U MOPR1'0%U nCipher DSE ESN:F528-3777-8A761%0#U Microsoft Time-Stamp Service0�"0 *�H�� � 0� � ��� �V�_�B2�m�����|8�X3�k�P��! ]��-�Z��.�L�ctX��ʼnT� ���y��!"m3��%@E�N c+�7�Oj�*�Z�W]�=�c�p>�"�[��2��q�y����W?t{��}|WX/���و�@ :"A� &���%Όg��F��M��f �s~;�v����tU��`Ab8�eF�fV��B�]Td/���8 k�.�>H�IVJ�i���4Jbl�n� ��\�c� �]��H�k�!/ �� 0�0 U X>�����1=6�� ]2�0 U #0�#4��RFp �@�v��+��5�0TU M0K0I�G�E�Chttp://crl.microsoft.com/pki/crl/products/MicrosoftTimeStampPCA.crl0X+L0J0H+0�<http://www.microsoft.com/pki/certs/MicrosoftTimeStampPCA.crt0U % 0 +0 *�H�� � ����~8��|�;R���#8��jY���o��oQj�:u�� ��N���$G$O5w���'{�]O�����)��@ R��vH~����["�c;2_5�Ƒ<����>�8z L�3ۿ�A�|$|� �K� ��9N!N�l|p��� ���x`܋��e�������\�|A�a-�Cge*�ԧ�Y�2��ō�"��(ذ�S�hGG����a��-�:lOo�=��)�D�Òg� �����1I���QHx� �@�0��0�Ԡ3 �� ��;�� �0 *�H�� 0y1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0 130124223339Z 140424223339Z0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1 0 U MOPR1 0 UMicrosoft Corporation0�"0 *�H�� � 0� � �\� �(|�{���v�(S?:�@}��3�W?�Q4T�ϴ��?�7�-P�5N�Mz�v��,�Y\����)u��'��-�A6+ @��;��\u�RK�3�7���~��A\e !7�,�" ��w"��|O�������� �N��� !��6G�/�j���5ܔW��K���8����zt�d�b�%.*�� �¯$�P�� �\I�y����p{(��*)Ͽ���qM��\#�)���J��'��~�C � �Oeq� ��`0�\0U % 0 +0 U Yq�Z3Mژ��� ���r2A�0QU J0H�F0D1 0 U MOPR1301U*31595+4faf0b71-ad37-4aa3-a671-76bc052344ad0 U #0����ҴX�7.3�L� 0VU O0M0K�I�G�Ehttp://crl.microsoft.com/pki/crl/products/MicCodSigPCA_08-31-2010.crl0Z+N0L0J+0�>http://www.microsoft.com/pki/certs/MicCodSigPCA_08-31-2010.crt0 *�H�� � 1�n*W3�՝��:�DM��^�j[�y���vh���� ����M��9� ���]$��:|ۭγ�l�9,E}$T&0 �G���f],{� �� �t�Oik��$��햠�s��j�Kb��|�H�M�D��<�mB��|���hh (����gR���s��c�J�>��N����;] �U?���@18u(^�Fm�zy@� ��Eծ�]>�u��fc`�՚���$0��4�c �BgJK�:ﶕ:�8�%���f�0��0��� a3& 10 *�H�� 0_10 �&���,dcom10 �&���,d microsoft1-0+U$Microsoft Root Certificate Authority0 100831221932Z 200831222932Z0y1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1#0!UMicrosoft Code Signing PCA0�"0 *�H�� � 0� � �rY\0d� �` B�vSl>�o����k����:t��/�2���BN#�r �5W �ʮ I��h�MK���yKq�G�%ߝu�ϪsDׁ���6��\Eܯ�=�(h���rsV���5�r��v_ wE��8�s[�gR���i/� ��t)�v/T�0Y�ҍb���_F1P�'�@0�r)("�7N=�2=�͡8�\NV�(*2�K�Oc��-b�E=� �F���[�&S�z�J�F�7<8��w\�����V<�� _� ��^0�Z0U �0�0 U ���ҴX�7.3�L� 0 U �0 +�7 0# +�7��1N�&���`;�1o�<��-0 +�7 S u b C A0 U #0���`@V'��%�*� S�Y�0PU I0G0E�C�A�?http://crl.microsoft.com/pki/crl/products/microsoftrootcert.crl0T+H0F0D+0�8http://www.microsoft.com/pki/certs/MicrosoftRootCert.crt0 *�H�� � Y9>&F��o@�2�j�/n�I��_u�L;-�C� ���-1�#�|P��!]�=/L���V��p����y�Ir�>�A�� i˥� -� P�V�-�JҼp� ��VชKW�B������ 4<�V��S#�*�� �� ��N�������N�ҏr�*qm�� �S�g�"�\ ͢��'�ycVD�Q��XVݛED/_�ڮԂ2n�����i穢,��+e�����& e8��z J���V��x�\�5_ݓ I�-��4D � ]�5[!Θ� ��OmN=|)H�r��l��p�W�W}���HZ�ϣg t�6�-/��r7�o�<g��R��3e ���d�o�F���y���,� ��� �'@���F�`Ge`@N�B�N�vy� 4 m �1 �T���G�d��P.|�!z�A'iÓ��ɍ؛!� \�𢮆h� j-�vk ���{��$���j�G1/���q=� ~bG�Έɸ�r���=�@j�i�����7P��=0�0�� ah4 0 *�H�� 0_10 �&���,dcom10 �&���,d microsoft1-0+U$Microsoft Root Certificate Authority0 070403125309Z 210403130309Z0w1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1!0 UMicrosoft Time-Stamp PCA0�"0 *�H�� � 0� � ��l���H�*|k.���řQ#P���N$�ѧ�L�t0 ��T�I�B���\0&� k�{������ �3$����g ,�{� ��N���#Sʍ�E� �^�аB���l�g�(�FS����(F.'��OUR �,�j��0n��Y0��~֗��!�~����SmR�E��H JGf')f�����J����G ����Ux�� P� 0F��#F��-T�� xA1w̛�;���a� ������"KT���� ���0��0U �0�0 U #4��RFp �@�v��+��5�0 U �0 +�7 0��U #��0�����`@V'��%�*� S�Y䤡c�a0_10 �&���,dcom10 �&���,d microsoft1-0+U$Microsoft Root Certificate Authority�y��J���LsX�.e0PU I0G0E�C�A�?http://crl.microsoft.com/pki/crl/products/microsoftrootcert.crl0T+H0F0D+0�8http://www.microsoft.com/pki/certs/MicrosoftRootCert.crt0U % 0 +0 *�H�� � ���\D6�鴭w��yQM�.tq[m �ξ{��.���mb�W�N P��z@�W��X� � ���x���;�⾏ ȍH��S�O����jՀ���/��*$"p����x�. ��p�N��k r���9�g-�Q�b\?�� ?�2��1Jv1=+r ��p=�� �� a���N��5+^���} B{�Sr!�0ʻxe\[ ����<�fX�-/���QV�p�l�9L�y��zb))4wb�= m �� �,��C���}�㤨t5�N�q#&v <R�qZFC����MgȟB��y!��0f�B^Ȟ"!�C�+��H�,��2�L&*H$_Z�V�ޙ��:o��'t�v!����'T��j=��va�n����G�o��2l���QȌ#�f�� �d=-�Y���!嵰�c�xT�A.P����x����uْ�u"/2�n�[�%����!�� Oɚ�I�eo� }�i��n꧗�1)��[\�M��/�?.Uk���1�(�0�(�0��0y1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1#0!UMicrosoft Code Signing PCA3 �� ��;�� �0 + ���0 *�H�� 1 +�70 +�7 10 +�70# *�H�� 1�y�,x�"�A,���*Ô��0R +�7 1D0B� � S Q L S e r v e r 2 0 1 4� � http://www.microsoft.com/sql0 *�H�� � -�M�P� _��K�f�D�v=CR�JX��4��+H�i��|� |8e+5AuK��s�^|�&=D30��6gBv8B�m�v��t�/D��g�u(�0᳜;��5���ŝ!�N'��:] K�=M>��7C�^ �Q���phix�MkU^���[���f �MjO�&���^Vj�We�������$���l�\����M4�d�+�fŗ�]�[`,��:W�k�x�=M��� ��&�� �E�c[$U�+��9�\硂&E0�$ *�H�� 1�0�0��0w1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1!0 UMicrosoft Time-Stamp PCA3 3�'��J*� 30 + �]0 *�H�� 1 *�H�� 0 *�H�� 1 140221132605Z0# *�H�� 1 ¼�^Wgb���U{ae`�$0 *�H�� � f�C؆~��\e�:*c&ۻƜPx�YY�+۴أ;�p�G �{��-"���y��er�э�Y~��)���B�4>|ߍ�* :W:w�Y���Aq-u�5��Ž S9� �Қta�� a�Q~���H�,�0�?CNj�4h��:�\���t8���$ ����[�'�Ǎ~�s��-Y�@� % y=ɩ[�Uc<=�a9���p���<@���c��IR�2�: W��Hd.t���%S�sa�$ �>B�rd���8��Ud0�$ +�71�$ 0�$ *�H�� ��#�0�#�10 `�He 0\ +�7�N0L0 +�70 ��� 010 `�He �r�P�e� ~�y��G��d�l�['0�� �0�0���3 w�t��� 0 *�H�� 0~1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1(0&U Microsoft Code Signing PCA 20110 130924174141Z 141224174141Z0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1 0 U MOPR1 0 UMicrosoft Corporation0�"0 *�H�� � 0� � �|/- ��z�4�L?I ���R�&�q�b'7��0�bl �� ��̕� Z����W0<]b��]� �4���5�#����J�9�/q��,7�p�>�*FЎǹH �7����� kJ*��L p�|�hB�<�R�>2�=~��K\��Å l0s�ɨ}���s�[{/ �2����;���_�|�W��^5���44�����F ���U���9�ae�)�7�nBU��5�R�p��4�)6�_ � ��0�{0 U %0+ +�7L0 U $+=ʐ��(ur<� �=�$VY0QU J0H�F0D1 0 U MOPR1301U*31642+2860b52e-c4a3-454d-bc1e-32c5add17e900 U #0�Hnd�Pӂ�77"�m��u�0TU M0K0I�G�E�Chttp://www.microsoft.com/pkiops/crl/MicCodSigPCA2011_2011-07-08.crl0a+U0S0Q+0�Ehttp://www.microsoft.com/pkiops/certs/MicCodSigPCA2011_2011-07-08.crt0 U �0 0 *�H�� � r` �&�f�8X��l�#�`-A(�k?�r�>bQeY1Q ?� 86�)�x�Tm��.D��Q�>�PE��¼yn[[4��19�#Y��L��O�b�W�I~���"F�m� �) ��mʀ������̀y����CL�fj�K�m� [с ��Ő/T��`$!�m4˒���@B� ?�e�[ʀ�ڎ�Z���K��ob��.�O( ��͑G �6�c���zX�[��f�����Xz��� {�I� �>ò���gH�u���l����W�o|H�H�O� �l$d �����]�/? Q\j��L�Lz_��N5�k���Z(�H�S���,��Ĥ�Q&� ~����{��c���\B�dw�1� �_ˤ�h��({z�rF �"}L �0�1 ��'�FE`-����TyFM�0�� +0�r�A��%��y�&��f=�����A3�wF�%���H�m[@�&�9 �����Ӥd��z�!�#{����<\� �S��_P0�z0�b� a�� 0 *�H�� 0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1200U)Microsoft Root Certificate Authority 20110 110708205909Z 260708210909Z0~1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1(0&U Microsoft Code Signing PCA 20110�"0 *�H�� � 0� � ��r .��n��M4��X!�B*k�ZP��8I�� �7k�� �8��9�1BӉ yd�~�`$l��I��h^�ߛS� ,ï٩+�z �זY�`�fv�2R&/�PϳD�]��.u�h��m�:\��F��8d�nd5x��c-�@���� �\y�I)� ��w��=��+Z MV(�zr�:�I^���C���{�{��>��]�O��/Y�;-�3Xŷ>�2ӳ=����8~ҝ�,�NV�!5%�9ndS���#������_��R������!t%_(��'(8%�9J6�|��� #��f�a j�(I�_��%]�!K>RĵW?$��z[/�#�p]QFw�� Ἤ�_����UK�9��#I��D|E��rz�r�$߿F���� Wۃ��MI0�����[���ݰf��{���K�I)�(��}g��bx_�/��W�\�w((��m�(�,�@7O��D�� L�ԥC/t��n�x X,]`��>O3�ڰ�ޞN�F�l���ֈ� ���0��0 +�7 0 U Hnd�Pӂ�77"�m��u�0 +�7 S u b C A0 U �0U �0�0 U #0�r-:1�C�N���1�#�40ZU S0Q0O�M�K�Ihttp://crl.microsoft.com/pki/crl/products/MicRooCerAut2011_2011_03_22.crl0^+R0P0N+0�Bhttp://www.microsoft.com/pki/certs/MicRooCerAut2011_2011_03_22.crt0��U ��0��0�� +�7.0��0?+3http://www.microsoft.com/pkiops/docs/primarycps.htm0@+04 2 L e g a l _ p o l i c y _ s t a t e m e n t . 0 *�H�� � g�Ty.��tg"� ��c��B�}�y ��e_.,>��r�m���?� �;�G���i�c�"5��]e��}�FPU� �|�K �<B�Rа�k�>.)��=�Ե w�9��d�D=xz#�}��t����&F*��� ��h�h.��*?*kXIc inZ�����F+�;н5�n%��'������(��M= ��� �2���-�[��I9 � �ƭ�����QEX82q'��'��,: i��Y�hno��t�@�*(>�?Mf ��M�� o}E�v�@*e��]Rb�� c6��������'�ͥ���]cA�[��>w��u �aa������A�(��e/��\�� ֡F�Y� KH�� � )ű��?Ew 5�Ң��zz"�H� ��G#�����k�K���ux��7�yK�ֳ#hu���� ��i;��0�L���umc�=ѝVNO��W"�x2!z�A �?��̤]����WqVNHE�Bɛv[ �Hk�y���mmj�Rs zP�1��0��0��0~1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1(0&U Microsoft Code Signing PCA 20113 w�t��� 0 `�He ���0 *�H�� 10 *�H�� 1 +�70 +�7 10 +�70/ *�H�� 1" �9�� �1�舊�v~���{�มN"�a γY0R +�7 1D0B� � S Q L S e r v e r 2 0 1 4� � http://www.microsoft.com/sql0 *�H�� � �ߑ�ǁ�]Wb��k�ݑ�'^���9��R�� ��Q=��S��O�b�ҧ��Q9N�L��Ƀ��[�.$�q���-T�ў��ki�#�c����ͤ�t�B�0�����( ����!�Қ���7����m �4Ē� ����W�%�@ԓ� >.EC�k��VU�����h��;� ʨ� 焤w���XV���!�10z�S�۫�Q�?�aP+,9s0�!F䖱ߙ���7���/� �v&V����M0�I +�71�90�5 *�H�� ��&0�"10 `�He 0�= *�H�� ��,�(0�$ +�Y 010 `�He ᘍt&\��E�_>�[N' �Q�"��3��*�Rޙ���20140221132607.096Z0�����0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1 0 U MOPR1'0%U nCipher DSE ESN:BBEC-30CA-2DBE1%0#U Microsoft Time-Stamp Service���0�q0�Y� a �* 0 *�H�� 0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1200U)Microsoft Root Certificate Authority 20100 100701213655Z 250701214655Z0|1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20100�"0 *�H�� � 0� � � �w�: ����i�ktTե ����|hK,_���a�v�>f+[�S'1 A� � �|a0Y�0D�`��TC �M�8�Bݓ��s0W&��E ��G�Ϳ$`2X`F�XG�2� tag�_�T�ϓL��Ħ]�an(������a�F�' $gr!��Kd�Pb�]�w =�Wu���BM@Q��>g�f��D~��K�n�ʱ��z* 1��N���5�x ���<�/D����d��� �x����D]^�O"M ���0��0 +�7 0 U �c:\�1��C{|F�3hZ�mU0 +�7 S u b C A0 U �0U �0�0 U #0��Vˏ�\bh�=��[�Κ�0VU O0M0K�I�G�Ehttp://crl.microsoft.com/pki/crl/products/MicRooCerAut_2010-06-23.crl0Z+N0L0J+0�>http://www.microsoft.com/pki/certs/MicRooCerAut_2010-06-23.crt0��U ���0��0�� +�7.0��0=+1http://www.microsoft.com/PKI/docs/CPS/default.htm0@+04 2 L e g a l _ P o l i c y _ S t a t e m e n t . 0 *�H�� � �Q ���?�q=���!o���1����Wm0���f�j���x�Ǩ�%��kTW+Q�D��S���`�v�@@A��\�\�^5�$VKt�Bȯ���7}Z? �yJ�R �8�/y�e٩�k����z oK0D$"<�����Y)����p�2J'�U�/���3�b_��W@��Ιf���jb��J �&�9�Jqc�{!mÜ��<�}�j�x�m�� �8ؔ�ƥ ������B�����"8 �%�d��~cY%z.9Wv�q����a�˚�G����ͧ��}���;q �]t�"aڰP o��� ��1��:�eGx�H���r~akow��˧ �9�����r� � ���*T9�[�� U�z�s;�-��3.)��/T'!�ȬN�(���ۖ��B���AM�*��f0ӻt2K�c{���/�!�Y���D<�Pqס��U�i�W���0����M� �]O� 8/��X.� �P5�� ' ճ~5 ��6��_��t�I0��0� 3 ,�)w;g�� ,0 *�H�� 0|1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20100 130327201315Z 140627201315Z0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1 0 U MOPR1'0%U nCipher DSE ESN:BBEC-30CA-2DBE1%0#U Microsoft Time-Stamp Service0�"0 *�H�� � 0� � �w�PT�)�d�"ז33=�{�{0V(8�Mh��} �E|jt@<v�E�|�)�� .���h�nks+<, ~�� �2cᗗr���=����� B%^� �[�!�5�S�d�:"�R��u �O[��� �� �f�� ��f KP{�o�:���O,�jY�r�|��`2���� �:3�pλ���=�� ۮ�k��p�qRqF|ٸ���M��ƣ�c�[ɣ q:���> je�g�2�}( �F{ �ࢯ٠/i�$a|c� ��0�0 U |͂�C��Z@ƫ�Bۗ��0 U #0��c:\�1��C{|F�3hZ�mU0VU O0M0K�I�G�Ehttp://crl.microsoft.com/pki/crl/products/MicTimStaPCA_2010-07-01.crl0Z+N0L0J+0�>http://www.microsoft.com/pki/certs/MicTimStaPCA_2010-07-01.crt0 U �0 0U % 0 +0 *�H�� � E`������_گ� �����St:'�:)�Z ��]-��"Y0S�d�T����.��#`���LT{0���A}��ܤLÊ?+%�!��p�f y� ���xBDo�To��Z��V~�<l�h`a���/�#�|���S��ʚ�1�G I�c�*�)�ݺh����Cҟ��|Q4:2m�m���a�I��'ܧ�� �tق&j51�tm[�ޝ�'-��|qtϸ�n� �@�$%���2aC�e��.��y0�a0�㡁����0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1 0 U MOPR1'0%U nCipher DSE ESN:BBEC-30CA-2DBE1%0#U Microsoft Time-Stamp Service�% 0 + �7Y��)9l�s9�C��6�j:Z���0�����0��1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1 0 U MOPR1'0%U nCipher NTS ESN:B027-C6F8-1D881+0)U"Microsoft Time Source Master Clock0 *�H�� ֱ�0"20140221002638Z20140222002638Z0w0= +�Y 1/0-0 ֱ� 0 $��0 �0 ֲm> 06 +�Y 1(0&0 +�Y � 0 �`� 0 � 0 *�H�� � G��]�"�>t�*i�ZJ@��Y�/�����o5������<�=� :<k^y��d��}� �X~e��",CB.��i����mc���_�T�t2�� �> #O�p�Fg^ �_ģ�n�N �j��b�ȆUO��Խi�e��d��j�K�X�~k��I&��O'�����/��6w-���&>�Lk h���L� ��E�W��6�g�}��Y[h��lc~�G�]V��}S�c}���W���,��X� l � ��a��1��0��0��0|1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20103 ,�)w;g�� ,0 `�He ��20 *�H�� 1 *�H�� 0/ *�H�� 1" q���UD/�l��� �e�W�H�I��4��c�Ǔ0�� *�H�� 1��0��0��0���7Y��)9l�s9�C��6�j:Z0��0���~0|1 0 UUS10U Washington10URedmond1 0 U Microsoft Corporation1&0$U Microsoft Time-Stamp PCA 20103 ,�)w;g�� ,0 �&�����Q��)�4ɵWti0 *�H�� � hz�PH�S����e�eZ�L�#YLҧ6M^ ��^?s$����+$�E=w� H=���K����U�t�$�p�ї=:!=KKE� H����+�kR�[<�.��eN�2W��" �1*p� ��I��ƴW�� Q��*�.��d�Tf`�́6o~ᩨ�� �� c��RԵ� #�X ��q\�Y�^`�GS*��y#��М�{|mC�]3|�*\������.�d���i-�+\�]]ɓP��i sc��
Close
