Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khermann
Starting Member
10 Posts |
 Posted - 2009-04-22 : 16:40:34
|
| I've been on a couple of performance engagements which included Microsoft where my customer had Spotlight installed and configured on a production OLTP instance. In both cases Microsoft required Spotlight be removed, citing historical negative performance observations from it. In both cases, in the end Spotlight was not identified as a particular source for trouble but Microsoft recommended it not be re-implemented in production. I have also consulted with DBA's whose opinions I respect who feel similarly.During those engagements there was no resistance to this guidance, and given all the ways to get health and performance information otherwise I did not challenge this guidance or dig in to the "why's and what's". Professionally from what I've seen/used of the tool I have difficulty finding the value against the, however measured it might be, somewhat invasive nature of the install. Like a lot of DBA's I am discomforted by 3rd party databases imposing themselves on to my production instance if it is not directly assisting the application. But this is just a base reaction. Does Spotlight really present risk?Regardless, the subject has resurfaced with another client and I was hoping folks here might be able to weight in on this. Do you have Spotlight running alongside a production OLTP application, and if so what is your observation of it's impact? Any thoughts, observations from the field, or redirection to resources are greatly appreciated!Thanks in advance,kth |
|
|
|
|
|
Spotlight on Production OLTP instances