Get flash to fully experience Pearltrees
Overview The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SP2 release of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem. For example, if the system is experiencing waits for disk IO the dashboard allows the user to quickly see which sessions are performing the most IO, what query is running on each session and the query plan for each statement.
Many of you have used the SQL Server 2000 blocker script (see KB 271509 ) to help troubleshoot performance issues in SQL 2000. If you haven't used it, you probably use a script of your own that takes a similar approach, polling sysprocesses and virtual tables to detect blocking and other resource contention issues. In PSS we’ve started using a new performance troubleshooting script for SQL 2005; we call this one our "Perf Stats Script", since it's useful for troubleshooting lots of issues in addition to blocking. The script takes advantage of the extremely rich set of data exposed by the new Dynamic Management Views in SQL Server 2005.
Update: New Stuff from the latest update will be in RED . This list will grow as I find new tools. So if you know of some not on this list do post them in the comments.
When you restore a database backup to another server, you may experience a problem with orphaned users. The Troubleshooting Orphaned Users' topic in SQL Server Books Online does not outline the exact steps for troubleshooting this problem. This article describes how you can troubleshoot orphaned users. Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. Although the terms login and user are often used interchangeably, they are very different.
Schema migration tools for SQLAlchemy , designed to support an agile approach to database design, and make it easier to keep development and production databases in sync, as schema changes are required. Python 2.6 and 2.7 are supported. If you are interested in a Python 3 port you might want to help. Have a look at issue 93 for current progress. If you want to start a new project involving SQLAlchemy and have the need for database schema migrations use Alembic .