The most recent content from our members.
Without being able to see the entire SQL statement, it is difficult or impossible to make appropriate index changes or to refer it to developers for refactoring. LINQ / Entity Framework frequently generates queries that are much longer than this.
Description DPA stopped using the sp_OA procedures to collect O/S level metrics and started using DMVs. However, the metric O/S CPU Queue Length was not available within a DMV so it was excluded. This document explains how to add it back as a custom metric for SQL Server. Note that this code use the sp_OA procedures which…
I hunted around a while but couldn't find this in the KB or elsewhere.
Hi, I have a query with regards to the email alert >> query for token Monitordownlength gave me 3.08 minutes when the alert was triggered. i.e. This was the first email I received when the alert triggered which had the monitor length down time of 3.08 minutes. My query is that if the alert is triggered once the thresholds…
It looks like you're new here. Sign in or register to get started.