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 […]
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 […]
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 […]
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 […]
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 […]
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
Honored to be part of the speaker pool.
#gscc2020
Refactored for 2020,
#gscc2020 will still have...
+ door prizes!
+ partner exhibits!
+ community forums!
+ event merch!
+ interactive presentations!
++ from 55 awesome professionals!
And this year...
+ Capture the Flag challenges!
+ started early!
https://www.granitestatecodecamp.org
