×

Monitoring

How to Persist Information from Lightweight Query Profiling?

September 14, 2020

Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]

T-SQL Tuesday #130: Automate Trace Flag Consistency

September 8, 2020

I thank Elizabeth Noble (blog|twitter) for hosting T-SQL Tuesday #123. The topic for this month is Automate Your Stress Away. I also want to acknowledge Adam Machanic’s vision behind this project. I learned a lot from some of the #TSQL Tuesday’s and participated in a few. Thank you, Steve Jones (blog|twitter), for coordinating this program. If you […]

Stress Test Using sqlcmd Utility

August 17, 2020

I am writing this blog post for my own reference for future. Hopefully someone will be benefited in the process. Recently I was working on upgrading System Center Operations Manager and configuring alert for high CPU. I wanted the alert to trigger if CPU was above a certain percent for x consecutive polls. While simulating […]

SSMS Memory Grant Info

May 11, 2020

Over some time, SQL Server Management Studio has expanded memory grant information. Memory grant provides memory grant estimate as well as actual runtime memory grant information. In this blog post, I will explain each element of ‘Memory Grant Info’, so we can get a better understanding of what those numbers mean? I am using this […]

Ring Buffer Monitoring CPU – What do those values mean?

February 24, 2020

Here is a sample output of XML from sys.dm_os_ring_buffers where WHERE ring_buffer_type = N’RING_BUFFER_SCHEDULER_MONITOR’. What do those XML elements mean? In order to monitor CPU usages, you need to understand what each element means so you can use the values. I will explain each one in this blog post. ProcessUtilization Indicates the amount of CPU SQL […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

GO AND DROP YOUR BALLOT IN PERSON OR VOTE IN PERSON.

I dropped mine in person and took 16 days to get recorded.

... #Elections2020

GO AND DROP YOUR BALLOT IN PERSON OR VOTE IN PERSON.

IT TOOK 16 DAYS FOR MINE.

DO NOT LISTEN TO MEDIA!
DO NOT LISTEN ... TO POSTMASTER!

#Elections2020

📣 Public preview: Auditing of Microsoft support operations in Azure SQL DB and #AzureSQL MI. Learn more: ... https://bit.ly/37R75gN

Load More...