#sqlhelp I am trying to find a TSQL which can give me real time CPU usage (in %) for each NUMA Node. Tried finding the solution for a few hours, even asked in SQLHELP slack channel but found nothing yet. Is there even a way to achieve it via TSQL? tia.
#SQLServer
Want to stress test your Azure SQL or SQL Server database - I maintain a free tool for that - just updated with Azure MFA support
#dotnet#azure#sqlserver
https://t.co/vK9fZqFnjb
Bumping this new Azure Feedback item about making TF 3226 be enabled by default.
It only has 8 votes so far...
https://t.co/b96i9s6hy0
#sqlserver#sqlserver2022
@SqlWorldWide @erinstellato That's absolutely correct. I've been doing it but was missing a few things like statement level granurality while troubleshooting performance via QT. It seems Erin's course has what i was looking for.
#sqlhelp
Hey Fam - I am looking for a "complete" tutorial/training on QueryStore. May i get some links/suggesitons please? Something which is like basic to pro. Appreciate it.
@Dennes
Good Morning. Wanted to check if we will be recording Saturday's SQL Server 2022 sessions and have plans to upload them either on YouTube or on your blog? Thanks.
One of my windows guy reached out to me, asking help in restoring a DB. When i checked on server, sa was disabled and no other user was sysadmin. He said that it was a new Azure SQL VM, build from a MS provide image. Do we have such images out there? ugh
Any way, i can restore it? Logs on primary replica on primary cluster are also complaining but i cannot take it out of AG there but it is a readable DB on secondary server on primary cluster. Any help is really appreciated... TIA
#sqlhelp
Hey Fam, Need little help here. Have a DAG setup with some DBs and one of them is stuck in "REVERTING" state from 48+ hours. Its a little over 1TB. Checked counter value from os_performance_counter but no change in past 48+ hours. 3317 VLFs found using xEvent. continue..
Those this DB is sitting in reverting state on secondary cluster in DAG which is truly for DR but still fairly important. Now, all of my efforts of restoring it, takign it offline, single user mode, emergency etc.. aren't working (knew they wont but tried).. continue...