Imagine your SQL Server as a bustling restaurant. Orders fly in, chefs scramble, and ingredients are whisked around – it’s data in motion! Just like the restaurant manager keeps an eye on everything, SQL Server activity monitoring watches how your server handles its tasks. Think of monitoring as observing three key areas: So, how does …
What is SQL Server Activity Monitoring? A Beginner’s Guide Read More »
Use Case 1: SQL Partial Backup in Script mode: If there were a requirement of keeping a backup of SQL server object like Stored Procedure, Functions, Views, Users, permissions, or selected Table’s schema (May be with data) for any reason example to reduce space or time etc. Use Case 2: SSMS Wizard scripting Mode Automation …
SQL Server Scripting, Automation tool, Advantage Read More »
Does your current SQL monitoring solution only alerts in case of few issues and shows only overall report ? We have a SQL server Solution that can significantly reduce your resource time in : replicating issues and identifying customer’s reported issues. finding Root cause of problems. Much more issues identification and remediation with its fast deep analytical …
I am Chandan Sahu , Founder and Architect of SQL Planner Product. I have Master degree in computer application and 13 years of development experience in IT industry. “We help IT corporations and companies running their businesses on Microsoft SQL Server technology with our software product called “SQL Planner”. SQL Planner ensures that they get: …
SQL Planner uses sysadmin credential to show greater insight about SQL Server root-cause of slowness , issues , Errors without this it would be very much limited to certain alerts only and its basic metric report. Here is details, Where SQL Server SysAdmin user Credential are used within SQL Planner : Retrieve SQL Serve Agent …
Over time SQL Planner repository database may grow significantly and it is recommended to delete older data (6 days or as per your requirement) to keep its storage under control, to purge data Create an SQL Agent Job to delete older data from SQL Planner database : – Connect to SQL Planner host machine using …
Thank you for your interest in knowing ways of “Finding SQL server slowness root cause in a minute” with Free tools. We are doing it with the GUI free tool – SQL Planner, as manual methods could be extremely difficult and complex. Step 1 : I have pre-recorded a session in youtube site which you can …
Identify Bottlenecks, issue, Error, Slowness in SQL Server Read More »
Many a times when DBA / Developers need to generate backup report, the easiest way to generate it in SQL Planner tool is, navigate to Menu > Analyse Server (Report List) > Database Backup History Report Here it has option to generate Database backup History report for all servers you are monitoring or choose individual …
Run your SQL Server much faster without Increasing Server hardware configuration & Scaling. To improve server performance, there are several ways like “Increase Hardware Configuration” , “Scalable” etc… which increase Infrastructure cost a lot. If I let you know that without above the other way is to do by “Query Performance tunning” – You may …
