Finding SQL Server Slowness Root-cause in a Minute !
SQL Server Slowness
Uncategorized
Way To Earn Extra
Your Profile If your are into business development/ software Sales/ Consultant/ Developers/ DBA / Management/ Any individual and would like to earn from us. We have great program and invites you to be our “Affiliate”, with this program you will be asked to connect your contacts or any organization of your reach and understand if …
AZURE SQL PAAS DB Alert List
Alert Category (PAAS SQL DB) Rule Description (criteria to trigger email) CPU when System CPU average usage is continously greater than “N% (eg 60%)” since Current time – N minute Memory when System Memory average usage is continously greater than “N% (eg 60%)” since Current time – N hour Low Database (Data, Log File) Space …
Why should you have SQL server monitoring solution in your organization ?
just try to answer below questions : 1. Do you know your SQL Server in production is having blocking / Deadlock causing loss in business ?2. Do you know historical high CPU usage at specific hour that may slow down SQL server performance ?3. Do you know if Disk usage is being excessively used and …
Why should you have SQL server monitoring solution in your organization ? Read More »
Un installing Change My Folder Icon
We are sorry you faced difficulty while uninstalling Here is step to uninstall : Download our product from below link , extract from zip folder and run ChangeFolderIcon_Setup.exe , move to Uninstall Tab > Click Remove Now Once Remove Now completed. To recover Windows default folder icon : Please delete a folder called “Icon-General” …
DBA Shift Handover notes management
Are you (DBA) sharing handover notes through email and it gets lost when it gets older , do you want to track it in better way and track all changes. SQL Planner has built in feature of this , watch demo here. to know more about features or download visit to official site : https://mssqlplanner.com/monitor-sql-server-and-analyze-ms-sql-server-health-from-any-device/ …
SQL Planner Alerts for SQL server
Alert Category Rule Description (criteria to trigger email) CPU when System CPU average usage is continuously greater than “N% (eg 60%)” since Last N minutes Memory when System Memory average usage is continuously greater than “N% (eg 60%)” since Last N hour Low Disk Storage When Disk Storage space is found to be less than …
Monitoring SQL server Always on environment
Monitoring SQL server Always on environment Monitoring all of your client SQL server Always on environment is now easy to monitor with root cause of any issue from one central place. Try Free version today , know more about the tool complete feature here : SQL Server Health Analysis, Monitoring Features (mssqlplanner.com) Demo Video :
Change My Folder Icon Help
How to change icon : Choose the folder whose Icon you want to change Right Click on that Folder and click on “Change My Folder Icon” Soon It opens a Pop up Window > Click on the Category of Icon from Left Pane > Click on Icon you feel is better as per your choice. …
MOST FREQUENTLY ASKED SQL QUERY
1.SQL Query to find second highest salary of Employee Answer : There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery : 1. select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from …