May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
frequently disconnecting

Personal Technology – Solution – Bluetooth KeyBoard and Mouse Frequently Disconnecting

July 14, 2020
Pinal Dave
Personal
Personal Technology, Windows

Today we are going to look at how we can fix the issue about frequently disconnecting with your Bluetooth devices like keyboard and mouse.

Read More
add folder

SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access

May 9, 2020
Pinal Dave
SQL Tips and Tricks
oStress, SQL Command, SQL Utility, Stress Testing, Windows

I was working with a DBA and he asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access.

Read More
listener creation

SQL SERVER – Always On Listener Creation Failure – Enabling Object ProdListener Failed With Error 5

February 8, 2020
Pinal Dave
SQL
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster, Windows

I have written a few blogs where I explained a few issues about the failure of listener creation failure in a cluster. Let us learn about it.

Read More
Measure Transactions

How to Measure Transactions Per Seconds in SQL Server? – Interview Question of the Week #262

February 2, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Performance, SQL Scripts, SQL Server, SQL Transactions, Windows

Question: How to Measure Transactions Per Seconds in SQL Server?
I have updated the script for this for Comprehensive Database Performance Health Check.

Read More
failure

SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5

January 21, 2020
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Computer Network, SQL Error Messages, SQL Log, SQL Server, SQL Server Cluster, Windows

I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.

Read More
task manager

Task Manager – Confusing Story of CPU

November 26, 2019
Pinal Dave
SQL Tips and Tricks
CPU Threads, SQL CPU, SQL Scripts, SQL Server, Windows

Clients hired me to help with the Comprehensive Database Performance Health Check. We will talk about a very Confusing Story of CPU of Task Manager.

Read More
lock page

SQL SERVER – Enable Lock Pages in Memory LPIM

September 16, 2019
Pinal Dave
SQL Tips and Tricks
SQL Memory, SQL Server, Windows

In this particular case, we had memory issue and after careful investigation, we found the troublemaker as a Lock Pages in Memory settings.

Read More
1 2 3 4 5 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version