The following 3 scripts will give you information about your database tables… . . . → Read More: How to find information about your database tables
|
|||||
|
As I have written previously, the Implicit Conversions can be a performance problem and they can be easily avoided. . . . → Read More: Query the cached plans: Implicit conversion Have you wondered how many open cursors are running on your system? . . . → Read More: Currently open cursors Here is a query which will return all adhoc queries which are used only once and the result will be sorted by the size . . . → Read More: What is bloating my plan cache? I would like very much to have some of the currently cached plans saved so I can compare them to the newly generated cached plans after the restart. Why would I like to do that? There are several reasons: to be able to query the currently cached plans – I would like to work with the cached . . . → Read More: How to take a “snapshot” of your cached plans  |
 |
||||
|
Copyright © 2010 Feodor Georgiev's blog - All Rights Reserved |
|||||
|
|
|||||
