While Optimizing SSIS packages, analyzing package log is really a pain as these log files are flat files and long so I lost focuses while reviewing. I was looking for a smart tool to analyze the my SSIS logs and figured out this utility (SSIS Log Analyzer) , which is freely available at Microsoft. This [...]
Category Archives: Useful Tools
How to TEST SQL Server Storage drives ?
Posted by Mahesh Gupta on July 10, 2011
0 comments
How will you check, how your SQL Server Drives are performing ? What is the throughput of the Disk Drive / Storage where your Database file resides ? What is SQL Server Storage speed ? is that fast on write operations or fast or read operations ? All this questions can be easily answered by [...]
SQL Server Developer Tool "Juneau" ???
Posted by Mahesh Gupta on December 14, 2010
2 comments
"Juneau" is going to be a high productivity development environment for SQL Server, SQL AZURE and Business Intelligence. By using this new tool "Juneau", developers will be able to do Connected and Offline database developments. Juneau is not product name, this a code name like Denali. "Juneau" is not yet released this is still product [...]
Find All SQL Servers in your Local Network
Posted by Mahesh Gupta on September 21, 2010
2 comments
Today, somebody asked me, how can I find what all are SQL Server Instances are running in my local network. I was shocked, I thought every DBA must know, what SQL servers are running in your network. This question was being asked by a sys admin guy, who wanted make an inventory list by finding [...]
SQL Server Monitoring tool – Performance Advisor for SQL Server
Posted by Mahesh Gupta on August 1, 2010
0 comments
I was looking for a some good graphical monitoring tool for SQL Server. I am totally amazed to see the features available in SQL Server Sentry “Performance Advisor for SQL Server”. This is amazed software, I suggest all guys to test at least the trail version once. Monitors and displays the most important Microsoft Windows [...]
