This tool only works for SQL Server 2000 instances since the Pinned Table feature was removed in SQL Server 2005 and later. |
The Table Pin tool allows you to manage pinned SQL Server tables. Pinning tables into SQL Server memory can provide performance boosts when SQL Server accesses those tables. Despite the performance benefit, this feature can become dangerous and cause serious performance issues when misused. With this tool, you can:
By default, Table Pin connects to the specified SQL Server instances using the credentials of your currently logged on Windows account, and then determines which database tables are pinned to the SQL Server memory.