Comments (1)
Now, all the SQLMonitor job name will reflect either in Client App Name
or Client Host Name
within XEvent Metrics.
Below query can be used to determine performance metrics of SQLMonitor jobs -
select xm.start_time, xm.event_time,
[job_name] = case when client_app_name like '(dba) %' then client_app_name else xm.client_hostname end,
xm.database_name, xm.sql_text,
xm.duration_seconds, xm.cpu_time_ms, xm.logical_reads,
xm.client_app_name, xm.username, xm.client_hostname
from dbo.vw_xevent_metrics xm
where xm.event_time >= dateadd(HOUR,-2,getdate())
and ( xm.client_hostname like '(dba) %'
or xm.client_app_name like '(dba) %'
)
order by event_time desc
from sqlmonitor.
Related Issues (20)
- We are getting the below error how to fixed this HOT 3
- We are getting error on two step 3__XEventSession and 9__CopyDbaToolsModule2Host HOT 2
- Add additional verification step for Instance-Availability HOT 1
- Add Flag for choice of `MemoryOptimized Tables`
- Show Counts of Issues on All Server Dashboard HOT 1
- Exception Tables for All Panels on All Server Dashboard
- Dashboard Exposing ErrorMessages from ErrorLogs
- Basic Slack Alerts for Core Metrics
- Setup Alert Engine Using Python+Postgres
- Add Infra to Track `AG State Change` HOT 1
- Infra to Support Password Rotation for `grafana` Login
- Change Retention of `dbo.all_server_volatile_info_history` to 15 Days HOT 1
- Create Alert for Severity 19 to 25 along with any specific Error Number
- Add Metric `Avg ms per disk wait` on dashboard HOT 2
- Add Collection Time on All Server Dashboard HOT 1
- Migrate `grafana` Login from Inventory on All Servers
- Add Preventive Triggers on `dbo.instance_details` to avoid Mistakes HOT 1
- Create Script to Add Alias HOT 1
- Add Check to Skip PowerShell Jobs Creation if Already Present on Another SQLInstance
- Add Switch to Create TSQL Script jobs as TSQL Step Type
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlmonitor.