<div>
addition to my &quot;The first tools are for free&quot;.<br />
They are already on your server <br />
- SQL*profiler is a part of your SQL*Server so you don't even have to install it.<br />
- performance monitor for your server monitoring<br />

</div>


addition to my "The first tools are for free".
They are already on your server
- SQL*profiler is a part of your SQL*Server so you don't even have to install it.
- performance monitor for your server monitoring


<div>
<div class="content wysiwyg-content">
I work for a small to mid-size business, and am a jack-of-all-trades: some application development, database design, technical support, etc. &nbsp;I have been working a lot lately with SQL server 2005. &nbsp;We have some databases that contain a large (for us) amount of info... anywhere between 5-20 million rows in the largest tables. &nbsp;I'm interested in purchasing any type of software that will assist with performance tuning on these databases. &nbsp;I doubt I manage updates/inserts/deletes the most effectively, but am not sure how to identify and analyze bottlenecks. &nbsp;Outside of getting a consultant (which we're open to, but that's a different question), do you have any recommendations on software to help us with this?
</div>
</div>


I work for a small to mid-size business, and am a jack-of-all-trades: some application development, database design, technical support, etc.  I have been working a lot lately with SQL server 2005.  We have some databases that contain a large (for us) amount of info... anywhere between 5-20 million rows in the largest tables.  I'm interested in purchasing any type of software that will assist with performance tuning on these databases.  I doubt I manage updates/inserts/deletes the most effectively, but am not sure how to identify and analyze bottlenecks.  Outside of getting a consultant (which we're open to, but that's a different question), do you have any recommendations on software to help us with this?

Performance tuning MS SQL 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.