×

Performance Tuning

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 […]

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 […]

UnmatchedIndexes – Bug in SSMS

January 21, 2020

Filtered Index in SQL Server and Parameterized Query does not work well with each other. This incompatibility is a well-known issue among Data Professionals. If you do a Google search for ‘SQL Server unmatched index‘ you find many articles written by well-known bloggers in the SQL Server community. I am quoting a summary of the […]

Did My UDF Inlined?

December 30, 2019

With the release of SQL Server 2019, CTP 2.1 new features were added to Intelligent Query Processing (QP) feature family. One of those features was Scalar UDF Inlining. You can read about the announcement by Karthik Ramachandra from Microsoft in this blog post. Karthik explained why UDFs are a problem when inlining is not done. Another […]


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

#sqlhelp
Is there an #azuredatastudio extension to see 'Always On High Availability' details like we see in SSMS?

Check out this awesome lineup of #speakers for @CsharpCorner SQL Virtual Conference!

Register Now: ... https://bit.ly/37q5QEE

@SavranWeb @javier_vill @SqlrUs @mssqlgirl @auntkathi @AnalyticAnna @bobwardms @BuckWoodyMSFT @dsavovic @erinstellato @skreebydba @matesic_damir @msteiu

Congratulations @KamalaHarris and @JoeBiden .
Can't wait for you to sign the reverse of illegal #MuslimBan later today.

@way0utwest @SqlWorldWide @TracyBoggiano @codewithsimon @AzureSQL @SQLServer @AzureDataStudio @csharpliveshow

... #SQLServer #SQL #Azuredata #SQLConference #sqldatabase #sqldeveloper #sqldba #sqlserver2019 #sqlqueries #sqlfamily #databasedeveloper #CsharpLiveShow

2021 DATA / SQL Saturday in Los Angeles submitted session:
The magnificent seven - Intelligent Query Processing in SQL ... Server @SqlWorldWide
RSVP: http://sqlsatla2021.eventbrite.com
#sqlsatla #sqlsaturday #microsoft #sqlserver2019 #intelligentqueryprocessing #performance #dba #azuresqldb

Load More...