Page History
...
- About Precise for SQL Server
- Components of Precise for SQL Server
- How Precise for SQL Server works
- What you can do with Precise for SQL Server
- Where to get more information
| Anchor | ||||
|---|---|---|---|---|
|
...
The SmarTune process detects performance deterioration by regularly analyzing SQL Server performance data, and identifying less than optimal behavior.
| Anchor | ||||
|---|---|---|---|---|
|
Use Precise for SQL Server to detect, diagnose and resolve performance problems in your SQL Server instance. Precise for SQL Server enables you to identify real-time performance problems (for example, locking problems) and monitor a complete history of your SQL Server instance.
...
The What-If tab shows the number of statements whose performance would improve and the number of statements whose performance would deteriorate by implementing the recommendation. It also shows the cost of implementing the recommendation so that you can weigh the pros and cons of implementing the change. Use the What-If option to evaluate a set of recommendations on the workload containing the most common Transact-SQL statements used by the application, during the selected time frame.
| Anchor | ||||
|---|---|---|---|---|
|
More information on Precise, its products, technical notes, and so on, can be found in the Release Notes document for this version.
...