r/SQLServer

I'm trying to get ahead, study and implement cursor/AI in my environment. I can create reports, i got a cool page that analyzes a query plan, but this is just simple stuff all DBAs can do. Im curious to se é what are you guys doing out there with AI in the database world.

​

To monitor the performance and availability for a thick client based system we recently delivered, the customer wants us to provide Here is the requirement:

1. Need to measure and report response time to Azure SQL queries for about 6 scenarios. Session counts, availability, utilization metrics for Azure SQL to be provided.

2. What native monitoring and metrics does Azure Files have to measure response times for files uploaded from devices connected to it.

What metrics needs to be extracted to measure all response times and how to be extracted.

This has to be measured for a period of 72 days with weekly and monthly reporting. Also, we do not have access to SSMS for Azure SQL and also the Azure Portal.

Thus , we need provide instructions to the customer IT Support team and they will provide the metrics and logs.

We have tried to get some help with AI tools but got conflicting response so need an Azure expert preferably Azure SQL DBA to help.

Much appreciated and thanks in advance.

PS: Application is thick client (yes I know) so no metrics can be pulled from endpoint devices. Don't ask why.

Friday Feedback this week comes from somewhere above the Atlantic Ocean. I spent the first half of this week with our team in Serbia and it was wonderful. For me, a few days of working with folks in person moves projects forward faster than weeks of online meetings.

One of the topics of discussion was persisting Automatic Plan Correction and manual plan forcing information in Query Store. If that would be valuable to you, what is the most important data you need retained? Bonus if you share how you'd want to see that data in a report/visual.

Enjoy the weekend!

Welcome to the open thread for r/SQLServer members!

This is your space to share what you’re working on, compare notes, offer feedback, or simply lurk and soak it all in - whether it’s a new project, a feature you’re exploring, or something you just launched and are proud of (yes, humble brags are encouraged!).

It doesn’t have to be polished or perfect. This thread is for the in-progress, the “I can’t believe I got it to work,” and the “I’m still figuring it out.”

So, what are you working on this month?

---

Want to help shape the future of SQL Server? Join the SQL User Panel and share your feedback directly with the team!

Never thought this would happen. But saw an internal opening in my company for a DB Engineering position. While I only had SQL and Azure SQL experience, I did not have the requisite other experience (python, automation, etc). However, I had a chat with the manager, and he decided to take me on.

I'll be coming on as a subject matter expert, evaluating their SQL requirements for some critical products, with the understanding I'll be learning other technologies in the DB engineering track such as a ansible, Azure DevOps, etc

It can happen, it's a long road, but no more on call support work and I can sleep better (that was a big motivator for me TBH).

DBA Dash now has an integrated query plan and deadlock viewer, which is also available as a standalone application (If you don't want to use DBA Dash as a monitoring tool)

Query Plan Viewer

There is also an SSMS extension that allows you to load query plans and deadlock graphs in the viewer.

Deadlock Viewer

Both have static and AI analysis and are packed with useful features and functionality.

The SSMS integration also allows you to load query results in the DBA Dash. The grid provides the following features

Sorting, filtering and grouping
• Data bars, which are remembered and re-applied next time you open results with the same columns
• Clickable XML/JSON columns, and plans or deadlock graphs in cells open in their viewers
• Export every result set to Excel, with one sheet per result set
• Script the results as INSERT statements into a temp table, so you can share them or query them further

SSMS Results to DBA Dash Visualizer

More info here:
https://dbadash.com/blog/whats-new-in-4.20.4/

DBA Dash has been around for 4 years - still is free and open source (MIT License). Updated frequently with cool new features like this! 😊

SCOM 2019 seems to have stopped detecting Availability Group Failovers in the environment.
All AG's are detected and stay in a Healthy State even when we forced a failover for testing.

Windows Cluster however are still firing the Cluster Alerts during tests.

SCOM 2019: v10.19
SQL MP: v7.6.5.0

SQL Version:
Microsoft SQL Server 2022 (RTM-CU12-GDR) (KB5036343) - 16.0.4120.1 (X64)   Mar 18 2024 12:02:14   Copyright (C) 2022 Microsoft Corporation  Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)

Browsing through the SQL MP doc seems like the AG is monitored and will alert by default, unless there is a config that I may have missed somewhere ?

Is this a possible MP mismatch with latest version of SQL on the server?

Anyone come across this scenario or has any ideas what i could check or change?

Any assistance would be appreciated