You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

 SQL Diagnostic Manager allows you to view a wide range of information collected for your monitored SQL Server instances hosted on Amazon RDS and Microsoft SQL Azure.

SQL DM supports monitoring of images hosted on virtualized or cloud IaaS environments such as Microsoft Azure and Amazon EC2.

 To have more information on the metrics data that are available for cloud instances, select your preferred option:

Available metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager

For monitored SQL Server instances hosted on Amazon RDS

SQL Diagnostic Manager AreaCollected Metrics by Amazon RDS
Sessions -> SummaryResponse Time
Sessions
Blocked Sessions
Lock Statistics -> Average Wait Time
Lock Statistics -> Deadlocks
Lock Statistics -> Requests
Lock Statistics -> Timeouts
Lock Statistics -> Waits
Lock Statistics -> Wait Time
Sessions -> Details
User Session
Status
Host
Net Library
Network Address
User
Application
Database
Transaction Isolation Level
Login Time
Last Activity
Physical I/O
CPU (ms)
Memory (kb)
Open Transactions 
Wait Time (ms)
Blocking
Blocking Count
Version Store Elapsed Seconds
Space Used in kb (Alloc / Dealloc) 
Session User Space
Task User Space
Session Internal Space
Task Internal Space
Overview -> DetailsBatches
Batches Per Second
Blocked Sessions
Buffer Cache Hit Ratio
Buffer Cache Size
Checkpoint Wrights
Checkpoint Wrights Per Second
Client Computers
Connections
Connections Per Second
Data File Count
Data File Space Allocated
Database Count
Full Scans
Full Scans Per Second
Lazy Writer Writes
Lazy Writer Writes Per Second
Lead Blockers
Lock Waits
Lock Waits Per Second
Log File Count
Log File Space Allocated
Log File Space Used
Log Flushes
Log Flushes Per Second
Maintenance Mode
OLE Automation Status
Open Transactions 
OS Metrics Availability
Packet Errors
Packet Errors Per Second
Packets Received
Packets Received Per Second
Packets Sent
Packets Sent Per Second
Page Life Expectancy
Page Lookups Per Second
Page Lookups Per Second
Page Reads
Page Reads Per Second
Page Splits
Page Splits Per Second
Page Writes
Page Writes Per Second
Procedure Cache Hit ratio
Read Ahead Pages
Read Ahead Pages Per Second
Read Write Errors
Response Time
Running Since
Server Version
Sql Compilations
Sql Compilations Per Second
Sql CPU Activity
Sql Memory Allocated
Sql Memory Used
Sql Recompilations
Sql Recompilations Per Second
System Processes
System processes Consuming CPU
User Connections Percent
User Processes
User Processes Consuming CPU
WMI Service Status
Workfiles Created
Workfiles Created Per Second
Worktables Created
Worktables Created Per Second

For monitored SQL Server instances hosted on Microsoft SQL Azure

SQL Diagnostic Manager AreaCollected Metrics by Microsoft SQL Azure
Sessions -> SummaryResponse Time
Sessions
Blocked Sessions
Sessions -> DetailsConnection
User Session
Status
Host
User
Execution Context
Application
Database
Transaction Isolation Level
Usage
Login Time
Last Activity
Physical I/O
CPU (ms)
Memory (kb)
Lock Information
Wait Time (ms)
Resource
Blocking
Blocking Count
Tempdb Usage
Version Store Elapsed Seconds
Space Used in kb (Alloc / Dealloc) 
Session User Space
Task User Space
Session Internal Space

Task Internal Space

Unavailable metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager

SQL Diagnostic Manager allows you to view a wide range of information collected for your monitored SQL Server instances hosted on Amazon RDS and Microsoft SQL Azure. However, the following information and metric data are not available yet:

For monitored SQL Server instances hosted on Amazon RDS

SQL Diagnostic Manager areaInformation and metric data not collected by Amazon RDS
Overview > Details

Available Memory

Data File Space used

Disk Queue Length

Disk Time (Percent)

OS CPU Privileged Activity

OS CPU User Time

OS Total Processor Activity

Pages Per Second

Physical Memory

Procedure Cache Size

Processor Queue Length

Sql Memory Used Percent

Used Memory(Percent)

Sessions > DetailsBlocked by
Execution Context
Resource
Wait type

For monitored SQL Server instances hosted on Microsoft SQL Azure

SQL Diagnostic Manager areaInformation and metric data not collected by Microsoft SQL Azure
Overview > Details

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Available Memory

Batches

Batches Per Second

Blocked Sessions

Buffer Cache Hit Ratio

Buffer Cache Size

Checkpoint Writes

Checkpoint Writes Per Second

Client Computers

Connections

Connections Per Second

Data File Count

Data File Space Allocated

Data File Space used

Database Count

Disk Queue Length

Disk Time (Percent)

Full Scans

Full Scans Per Second

Lazy Writer Writes

Lazy Writer Writes Per Second

Lead Blockers

Lock Waits

Lock Waits Per Second

Log File Count

Log File Space Allocated

Log File Space Used

Log Flushes

Log Flushes Per Second

Maintenance Mode

OLE Automation Status

Open Transactions

OS CPU Privileged Activity

OS CPU User Time

OS Metrics Availability

OS Total Processor Activity

Packet Errors

Packet Errors Per Second

Packets Received

Packets Received Per Second

Packets Sent

Packets Sent Per Second

Page Life Expectancy

Page Lookups Per Second

Page Lookups Per Second

Page Reads

Page Reads Per Second

Page Splits

Page Splits Per Second

Page Writes

Page Writes Per Second

Pages Per Second

Physical Memory

Procedure Cache Hit ratio

Procedure Cache Size

Processor Queue Length

Read Ahead Pages

Read Ahead Pages Per Second

Read Write Errors

Response Time

Running Since

Server Version

Sql Compilations

Sql Compilations Per Second

Sql CPU Activity

Sql Memory Allocated

Sql Memory Used

Sql Memory Used Percent

Sql Recompilations

Sql Recompilations Per Second

System Processes

System processes Consuming CPU

Used Memory(Percent)

User Connections Percent

User Processes

User Processes Consuming CPU

WMI Service Status

Workfiles Created

Workfiles Created Per Second

Worktables Created

Worktables Created Per Second

Sessions > Summary

Average Wait Time

Deadlocks

Requests

Timeouts

Waits

Wait Time

Sessions > Details

Blocked by

Net library

Network Address
Open Transactions
Wait type
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
        


  • No labels