Datasheet

DTS Server (for SQL Server Integration Services)
Full-text Search
SQL Browser
Profiler
Profiler has many features that allow you to analyze performance problems in
SQL Server 2005. For example, Profiler opens trace files that you store in the
file system, which allows you to replay and analyze interesting SQL Server
processes. Profiler can display a graphical representation of a trace so you
can easily see what is happening.
Profiler can import data recorded by using the Windows Performance
Monitor. You can display the data graphically, letting you see performance
over a selected period of time. From the graph, you can enter the trace at the
point where a problem lies — for example, where CPU usage spikes. You can
then closely examine what is causing a performance problem.
I don’t cover Profiler in detail in this book.
SQL Server Agent
The capabilities of SQL Server Agent, the component that supports sched-
uled jobs, have been enhanced. For example, the number of concurrent jobs
that SQL Server Agent can run has increased. SQL Server 2000 used SQL
Agent only in relation to jobs for the database engine. SQL Server 2005 also
uses SQL Server Agent to run jobs for Analysis Services and Integration
Services. I discuss SQL Server Agent jobs further in Chapter 16.
SQL Server Agent uses Windows Management Instrumentation (WMI). WMI
support allows you to write code to avoid running a job, such as when the
disk space is insufficient to let the job run successfully.
Dynamic configuration
In SQL Server 2005, you can make many configuration changes without
having to restart SQL Server (if you’re running on the Windows Server 2003
operating system). This is a big improvement over SQL Server 2000 when you
often had to restart SQL Server after making configuration changes. In SQL
Server 2005, you can change CPU affinity or I/O affinity if you need to. If you
have the necessary hardware you can hot-add extra memory to your server.
27
Chapter 2: New Features in SQL Server 2005
06_577557 ch02.qxp 12/20/05 9:43 PM Page 27