track high compilations\sec
From: Hassan (fatima_ja_at_hotmail.com)
Date: 01/19/05
- Next message: Mike Epprecht \(SQL MVP\): "Re: how to replace a whole role?"
- Previous message: Erland Sommarskog: "Re: How to load a Unicode file into the database in the same order as the file order"
- Next in thread: Andrew J. Kelly: "Re: track high compilations\sec"
- Reply: Andrew J. Kelly: "Re: track high compilations\sec"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 Jan 2005 15:33:02 -0800
I would like to track the high compilation\sec ( averaging over 10) on a
server. Also the recompilations\sec are averaging at 0 which seems to be
odd.
So whats compiling and not recompiling and why ? How can i track it down ? I
looked at Profiler but i see a recompile event. Any easy way of tracking
this.. Besides Ive got around 2000 batch requests\sec on this server and
running profiler would bring it to its knees.
Please provide suggestions with reasoning for why that may be so
- Next message: Mike Epprecht \(SQL MVP\): "Re: how to replace a whole role?"
- Previous message: Erland Sommarskog: "Re: How to load a Unicode file into the database in the same order as the file order"
- Next in thread: Andrew J. Kelly: "Re: track high compilations\sec"
- Reply: Andrew J. Kelly: "Re: track high compilations\sec"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
