August 14, 2008 at 7:43 am
Should developers be allowed to use Profiler in development and test regions?
All opinions appreciated, thanks!
August 14, 2008 at 7:49 am
I think they should if they will to trace code. However they should be careful not to make sysadmin type changes if they have rights.
August 14, 2008 at 8:36 am
rocky (8/14/2008)
Should developers be allowed to use Profiler in development and test regions?All opinions appreciated, thanks!
In dev and test, I would say yes. It helps a lot in testing and debugging of code. On production, no, I would not give access.
On SQl 2005, people no longer need sysadmin to run profiler. There's an ALTER TRACE permission that can be given to people that lets them just create, start and stop traces
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 14, 2008 at 9:02 am
We permit traces in development, but not in QA. Our developers have no more rights in QA than they do in production. This prevents QA from becoming a second development environment. But, in general, yes.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply