SQL-Server admin sqlQuery to view the running stats on the server

SQLServer SQL-Server: admin SQL Queries to view the running stats. I have used this frequently on SQL-Server 2016 for day to day activities and useful for me most of the time. You can also try this if you are a admin or developer or user of sql server.
In this article, tried to share few tsql/sql server admin queries as:

  1. get list of connected users and its sessions
  2. get list of long running cursor
  3. get list of idle session that has open transaction(s)
  4. get information about own query and connection info
  5. Get information about blocked request

Continue reading SQL-Server admin sqlQuery to view the running stats on the server

why health-check service is required for Load Balancer?

Let us understand, why health-check service API is required for any LB (Load Balancer)? Checking of health, whether underlying node/application/webServer is up and running or not. Health-Check is most important and  basic things, when you add your application server or web server under LB( Load Balancer) (LB can be either SLB- Software Load Balancer or HLB – Hardware Load Balancer).

Continue reading why health-check service is required for Load Balancer?