In this particular case, we had memory issue and after careful investigation, we found the troublemaker as a Lock Pages in Memory settings.
SQL SERVER – Power Options, Power Plans and Database Performance
A client’s server slowed down with no CPU, IO or memory issue. The culprit was power options. Here is how power plans and database performance connect.
Personal Technology – Bluetooth Volume Problem with Windows Volume Control
In today’s blog post, I will discuss one of the issues which I face while using Bluetooth Volume with Windows Volume Control.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
SQL Server Configuration Manager missing from the Start Menu? Open it directly from C:\Windows\System32 with the SQLServerManager msc file for your version.
Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly
Launching Visual Studio on my VM failed with: The ‘SqlStudio Profile Package’ package did not load correctly. I gathered a list of fixes that can solve it.
SQL SERVER 2019 – Oracle JRE 7 Update 51 (64 Bit) or Higher is Required
Installing SQL Server 2019 CTP with all features, setup stopped me with: Oracle JRE 7 Update 51 (64-bit) or higher is required for PolyBase. I explain why it asks.
SQL SERVER – FIX: CREATE FILE Encountered Operating System Error 5 (Access is Denied.)
After a disk migration on a cluster, SQL Server would not start: CREATE FILE encountered operating system error 5 (Access is denied.) on TempDB. I share the fix.