SQL Server Components

SQL Server Notification Services Performance Tuning

SQL Server 2000 and 2005 Notification Services can be a heavy burden on a SQL Server, depending on how it is used. For best overall performance, it is recommended to dedicate Notification Services to a dedicated SQL Server. For example, let’s say that you want to use Notification Services to handle e-mail notifications to your […]

SQL Server Full-Text Search Performance Tuning and Optimization

The SQL Server Full-Text Search service can affect the overall performance of SQL Server when it is indexing text in your tables. Indexing large amounts of text uses up server resources, reducing the CPU time and memory that could be used by your users running their SQL Server-based applications. If you find that the Full-Text […]