Folder SQL Server Check

Last updated 11 November 2020.

 SQL Server Check - Performance troubleshooting and profiling for Dynamics NAV | BC and SQL Server

Checks SQL Server in scope for some of most common skewed Best Practices and performance issues.
Valid from SQL Server 2012 onwards. By default all databases in the SQL Server instance are eligible for the several database specific checks, and you may use the optional parameter to narrow these checks to specific databases.



 Contains the following informational sections:

 General
Version
Uptime 2.0
OS Version and Architecture 2.0
Disk space 2.0
HA Information 2.0
Linked servers info 2.0
Instance info 2.0
Buffer Pool Extension info 2.0
Resource Governor info 2.0
Database Information 2.0
Database file autogrows last 72h 2.0
SQL Server Configuration 2.0
Feature usage 2.0
Backups since last Full Information 2.0
System Configuration 2.0
Clean up temp objekts 2.0

 Processor | Memory | Pagelife | IO
Version
Number of available Processors 2.0
Historical CPU Utilization SQL vs Other Processes 2.0
Additional Processor information 2.0
Server Memory 2.0
SQL Server Buffer Detail 2.0
LPIM 2.0
Pagefile 2.0
SQL Server Signal Waits 2.0
Memory Usage Status 2.0
MAX DOP Recommendation 2.0
Memory Information 2.0
Pending disk I/O Requests 2.0
Check for HP Logical Processor issue 2.0

 Server | Service Accounts | Instance
Version
SQL Server ErrorLog 2.0
Service Accounts Status 2.0
Recommended build check 2.0
Global trace flags 2.0
System configurations 2.0
Errorlog based checks 2.0

 Database | TempDB
Version
DBs with collation <> master subsection 2.0
DBs with skewed compatibility level 2.0
User DBs with non-default options 2.0
DBs with Sparse 2.0
DBs Autogrow in percentage 2.0
Backups and Database files in same volume 2.0
Get IO Disk Usage Percentage By Drive Letter 2.0
Get IO Disk Latency Percentage By IO Stalls By DB 2.0
Get IO Disk Latencies Read/Write 2.0
SQL Server Databases 2.0
I/O Usage By Database 2.0
Using DBCC LOGINFO 2.0
DBCC CHECK DB Latest Date 2.0
DBCC SQL Perf 2.0
Databases Quick Object Report 2.0
Database Cache Size 2.0
User Table Heap DB Count 2.0
Find out who created the Temporary Table 2.0
TempDB Stats after Session 2.0
VLFs 2.0
Database Size Growth as a list 2.0
How old your Backups 2.0
Workload Analysis 2.0
Search Data for String 2.0

 Performance | Monitoring
Version
Hints usage* 2.0
Plan use ratio* 2.0
Perf counters, Waits, Latches and Spinlocks 2.0
Get Pending Memory Grants With Queries 2.0
Wait Stats 2.0
Wait Types Stats 2.0
Session Diver IP Monitor 2.0
Top Logical Reads Queries 2.0
Total Logical Reads 2.0
Wait Info Summary 2.0
Wait Info 2.0
Top 20 Blocked Queries 2.0
Top Worker Time Queries 2.0
Top 20 Query Response Time For Individual Queries 2.0
Execution Cache Single Use Plans Explore 2.0
Find Long Running Queries 2.0
Top Avg Elapsed Time Queries 2.0
Latch Stats 2.0
Session Diver IP Monitor 2.0
Blocking Live 2.0
Active Transactions 2.0
Log Buffer 2.0
Query Stats 2.0
Plan Statement Version 2 2.0
DBCC Opentran 2.0
SQL Monitor Version 2 2.0
SQL Handle Short 2.0
SQL Handle Long 2.0
Optimizer Info Martix 2.0
Most CPU IO Monitor 2.0
Transaction 2.0
Current Running Transaction Monitor 2.0
Check SP (Top 10) 2.0
Buffer Object per Database 2.0
Misleading SQL Server Performance Counters 2.0
Long Running Query SQL 2016 2.0
Query Plan Version 2 2.0

 Security | Maintenance | Naming Convention
Version
SQL Server Jobs 2.0
DBCC CHECKDB 2.0
SQL Agent TSQL Job Step Binary 2.0
Database Level Privileges 2.0
System health error checks 2.0
SQL Agent alerts for severe errors 2.0
Password check 2.0
SQL Server Agent Jobs 2.0

 Index | Statistics
Version
Check Old Statistics 2.0
Missing Indexes 2.0

V8 Search XE. Designed and built by Olav Treffurt IT Consulting. Copyright © 2021 DynamicsProject.com. All rights reserved.

Trademarks
Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, Dynamics 365 Business Central, Windows, Windows Server, and the other products listed on the trademarks page of the Microsoft website are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.