sp blitz KVQ8 20140709.pdf


Preview of PDF document sp-blitz-kvq8-20140709.pdf

Page 1 2 3 4 5 6 7 8 9 10

Text preview


sp_Blitz™ Report for SQL Server: KVQ8

Priority

Findings Group

Database Name

Finding
Non-Default Server Config
Database Mail XPs

200

This sp_configure option has been changed. Its default value is 0 and it has been
set to 1.
More information at: http://BrentOzar.com/go/conf
Non-Default Server Config
max server memory (MB)

200

This sp_configure option has been changed. Its default value is 2147483647 and
it has been set to 4096.
More information at: http://BrentOzar.com/go/conf
Performance
Agent Jobs Starting Simultaneously

200

Multiple SQL Server Agent jobs are configured to start simultaneously. For
detailed schedule listings, see the query in the URL.
More information at: http://BrentOzar.com/go/busyagent/
Performance

TraceDB

Old Compatibility Level
200

Database TraceDB is compatibility level 110, which may cause unwanted results
when trying to run queries that have newer T-SQL features.
More information at: http://BrentOzar.com/go/compatlevel
Reliability

SSISDB

Database Collation Mismatch
200

Database SSISDB has collation SQL_Latin1_General_CP1_CI_AS; Server collation
is Cyrillic_General_CI_AS
More information at: http://BrentOzar.com/go/collate
Security

SSISDB

Database Owner <> SA
200

Database name: SSISDB Owner name: SLAVUTICH\S_Kotlyarevskiy
More information at: http://BrentOzar.com/go/owndb
Security

TraceDB

Database Owner <> SA
200

Database name: TraceDB Owner name: SLAVUTICH\S_Kotlyarevskiy
More information at: http://BrentOzar.com/go/owndb
Security
Jobs Owned By Users

200

Job [Process CorpDW SndSale Orders PO and SSL last curr] is owned by
[SLAVUTICH\dwadmin] - meaning if their login is disabled or not available due to
Active Directory problems, the job will stop working.
More information at: http://BrentOzar.com/go/owners

Created 09:12:04 on Ср Липень 2014