Hi
There are many things that we want to do in SQL server which do not ship with the product but are still freely available. There are many free tools available for SQL server that are less known to the developers because they do not ship with the product. But these tools can be more than handy for many situations. And very importantly these tools are freely available from Microsoft.
Here is a list of tools available from Microsoft freely for SQL server 2000. [Note: These list is not exclusive. There are more tools available from Microsoft. Please check Microsoft’s Site for the same.]
Read80Trace - It is a command line utility for processing trace files generated by SQL Server 2000.
SQLIO - It is a tool provided by Microsoft, which can also be used to determine the I/O capacity of a given configuration.
SQLH2 Performance Collector - The SQLH2 Performance Collector is a stand-alone service of Microsoft Windows that collects and stores performance counter data from selected servers.
SQL Server 2000 Best Practices Analyzer - Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices.
SQL 2000 Check - SQL Check scans the computer on which it is running for instances of SQL Server 2000 and MSDE 2000 that are vulnerable to the Slammer worm.
SQL 2000 Management Pack - The Microsoft SQL Server 2000 Management Pack provides both proactive and reactive monitoring of SQL Server 2000 in an enterprise environment.
Thanks
Vikram