"Can we get a quick performance overview of all our SQL Servers?"
A perfectly reasonable request.
Until the answer involves 47 instances and a spreadsheet.
SQL DM 14.3 is bringing expanded enterprise reporting.
🦆 idera.com/sql-diagnostic…
#SQLServer
A perfectly reasonable request.
Until the answer involves 47 instances and a spreadsheet.
SQL DM 14.3 is bringing expanded enterprise reporting.
🦆 idera.com/sql-diagnostic…
#SQLServer
0
0
0
86
New SQL Server.
Healthy CPU.
Healthy memory.
Healthy disk.
Dashboard: EVERYTHING IS CRITICAL.
A spectacular opening performance.
SQL DM 14.3 is bringing retuned default alert thresholds for newly monitored servers.
🦆 Quacky has asked the dashboard to lower its voice.
First look → idera.com/sql-diagnostic…
#SQLServer
Healthy CPU.
Healthy memory.
Healthy disk.
Dashboard: EVERYTHING IS CRITICAL.
A spectacular opening performance.
SQL DM 14.3 is bringing retuned default alert thresholds for newly monitored servers.
🦆 Quacky has asked the dashboard to lower its voice.
First look → idera.com/sql-diagnostic…
#SQLServer
0
0
0
112
The best Friday deployment is the one that can wait until Monday.
Quacky has reviewed the change window.
He has also reviewed his weekend plans.
The weekend plans have won. 🦆
#SQLServer #DBA
Quacky has reviewed the change window.
He has also reviewed his weekend plans.
The weekend plans have won. 🦆
#SQLServer #DBA
0
0
0
212
There are two kinds of SQL Server maintenance windows.
The ones on the calendar.
And the ones that mysteriously become longer than anyone remembers approving.
🦆 Quacky has reviewed the schedule. He would like the weekend back.
#SQLServer #DBA
The ones on the calendar.
And the ones that mysteriously become longer than anyone remembers approving.
🦆 Quacky has reviewed the schedule. He would like the weekend back.
#SQLServer #DBA
0
0
0
268
The SQL Server needs attention.
Your Windows machine is elsewhere.
Naturally.
SQL DM 14.3 is bringing real-time instance monitoring to the browser.
🦆 First look: idera.com/sql-diagnostic…
#SQLServer
Your Windows machine is elsewhere.
Naturally.
SQL DM 14.3 is bringing real-time instance monitoring to the browser.
🦆 First look: idera.com/sql-diagnostic…
#SQLServer
0
0
0
107
Four databases.
Four sets of files, logs, indexes, and configurations.
One DBA expected to remember which tab belongs to which.
SQL DM 14.3 is bringing expanded database views with a selector that follows you between tabs.
Quacky approves of keeping your place. 🦆
#SQLServer
idera.com/sql-diagnostic…
Four sets of files, logs, indexes, and configurations.
One DBA expected to remember which tab belongs to which.
SQL DM 14.3 is bringing expanded database views with a selector that follows you between tabs.
Quacky approves of keeping your place. 🦆
#SQLServer
idera.com/sql-diagnostic…
0
0
0
87
The SQL Server job succeeded.
The application says it failed.
The logs have entered their mysterious phase.
Schrödinger's SQL Agent Job is alive and well.
🦆 Quacky is opening the box. He's brought the job history.
#SQLServer #DBA
The application says it failed.
The logs have entered their mysterious phase.
Schrödinger's SQL Agent Job is alive and well.
🦆 Quacky is opening the box. He's brought the job history.
#SQLServer #DBA
0
0
2
264
Somebody says, "The database doesn't need indexes. We have plenty of RAM."
A veteran DBA has just experienced seventeen years of flashbacks in approximately two seconds.
Quacky is preparing a presentation on the laws of physics. 🦆
#SQLServer #DBA
A veteran DBA has just experienced seventeen years of flashbacks in approximately two seconds.
Quacky is preparing a presentation on the laws of physics. 🦆
#SQLServer #DBA
0
0
3
330
Query Monitor has plenty to tell you.
Finding the useful bit shouldn't require an archaeological expedition.
SQL DM 14.3 is bringing a cleaner, easier-to-scan Query Monitor.
Quacky has put away his tiny excavation brush. 🦆
#SQLServer #DBA
Finding the useful bit shouldn't require an archaeological expedition.
SQL DM 14.3 is bringing a cleaner, easier-to-scan Query Monitor.
Quacky has put away his tiny excavation brush. 🦆
#SQLServer #DBA
0
1
0
167
Tomorrow, @pinaldave puts generative AI to work on real SQL Server tuning examples.
The interesting part? Where AI recommendations can be misleading or harmful.
Because a confident answer still deserves a second look.
🦆 Join at 10 AM CT: attendee.gotowebinar.com/register/78731…
#SQLServer
The interesting part? Where AI recommendations can be misleading or harmful.
Because a confident answer still deserves a second look.
🦆 Join at 10 AM CT: attendee.gotowebinar.com/register/78731…
#SQLServer
0
0
0
102
The SQL Server problem is familiar.
Finding every piece of evidence shouldn't be a second investigation.
Mark Slavens is taking us inside SQL DM 14.3 on Oct 29.
New Console, reporting, live Web Console monitoring, and more.
🦆 attendee.gotowebinar.com/register/28653…
#SQLServer
Finding every piece of evidence shouldn't be a second investigation.
Mark Slavens is taking us inside SQL DM 14.3 on Oct 29.
New Console, reporting, live Web Console monitoring, and more.
🦆 attendee.gotowebinar.com/register/28653…
#SQLServer
0
0
0
115
A query rewrite looks promising.
Then you check the execution plan.
Then the statistics.
Then the waits.
SQL Server tuning remains a fascinating profession. 😅
@pinaldave explores AI-assisted tuning on Oct 22.
🦆 attendee.gotowebinar.com/register/78731…
#DBA
Then you check the execution plan.
Then the statistics.
Then the waits.
SQL Server tuning remains a fascinating profession. 😅
@pinaldave explores AI-assisted tuning on Oct 22.
🦆 attendee.gotowebinar.com/register/78731…
#DBA
0
0
0
126
AI can rewrite your SQL.
It can also give you a very convincing explanation for a questionable decision.
Pinal Dave is digging into both sides with real SQL Server tuning examples on Oct 22.
Your DBA instincts are invited. 🦆
attendee.gotowebinar.com/register/78731…
#SQLServe
It can also give you a very convincing explanation for a questionable decision.
Pinal Dave is digging into both sides with real SQL Server tuning examples on Oct 22.
Your DBA instincts are invited. 🦆
attendee.gotowebinar.com/register/78731…
#SQLServe
0
0
0
113
A query rewrite from AI.
An execution plan with questions.
A DBA who has seen this sort of thing before.
Pinal Dave digs into AI-assisted SQL tuning with real examples on Oct 22.
🦆 attendee.gotowebinar.com/register/78731…
#SQLServer #DBA
An execution plan with questions.
A DBA who has seen this sort of thing before.
Pinal Dave digs into AI-assisted SQL tuning with real examples on Oct 22.
🦆 attendee.gotowebinar.com/register/78731…
#SQLServer #DBA
0
0
0
801
AI has some exciting ideas about your indexes.
SQL Server has opinions of its own.
Pinal Dave is exploring where generative AI helps with query tuning and where its suggestions can go sideways.
Oct 22 | 10 AM CT 🦆
attendee.gotowebinar.com/register/78731…
#SQLServer #DBA
SQL Server has opinions of its own.
Pinal Dave is exploring where generative AI helps with query tuning and where its suggestions can go sideways.
Oct 22 | 10 AM CT 🦆
attendee.gotowebinar.com/register/78731…
#SQLServer #DBA
0
0
0
165
AI can rewrite your SQL query.
It can suggest indexes, identify possible bottlenecks, and offer a very confident explanation.
Lovely.
Now comes the interesting part: deciding whether those suggestions deserve a place in your environment. 🧵
It can suggest indexes, identify possible bottlenecks, and offer a very confident explanation.
Lovely.
Now comes the interesting part: deciding whether those suggestions deserve a place in your environment. 🧵
1
0
0
294
A convincing recommendation can still be misleading or even harmful.
Execution plans, statistics, waits, indexing, and query behavior all matter when evaluating AI-assisted tuning.
The fundamentals still get a vote.
And so does the DBA.
Execution plans, statistics, waits, indexing, and query behavior all matter when evaluating AI-assisted tuning.
The fundamentals still get a vote.
And so does the DBA.
1
0
0
43
On October 22, @pinaldave is putting generative AI to the test with real SQL Server examples in a practical, demo-driven session.
Where AI helps, where it gets things wrong, and how to use it alongside proven tuning techniques.
🦆 Join us at 10 AM CT: attendee.gotowebinar.com/register/78731…
#SQLServer #DBA
Where AI helps, where it gets things wrong, and how to use it alongside proven tuning techniques.
🦆 Join us at 10 AM CT: attendee.gotowebinar.com/register/78731…
#SQLServer #DBA
0
1
2
1,055
A maintenance task retired because the evidence says it isn’t helping.
A shorter run. More breathing room.
What have you adjusted or retired after seeing its workload impact?
🦆 Quacky celebrates a shorter checklist as enthusiastically as a completed one.
#DBA
A shorter run. More breathing room.
What have you adjusted or retired after seeing its workload impact?
🦆 Quacky celebrates a shorter checklist as enthusiastically as a completed one.
#DBA
0
0
1
209
Today: Uwe Ricken, a real SQL Server instance, and 40+ minutes of live auditing demos.
Follow configuration, filtering, and log analysis. Bring your questions.
🦆 Notebook open. Wings ready.
5 PM CEST / 10 AM CDT
attendee.gotowebinar.com/register/55928…
Follow configuration, filtering, and log analysis. Bring your questions.
🦆 Notebook open. Wings ready.
5 PM CEST / 10 AM CDT
attendee.gotowebinar.com/register/55928…
0
0
0
161