March 4, 2008 at 11:54 am
Good afternoon-
I need to run the Tuning Advisor against our Production machine tomorrow (having about 20 SQL Server 2005 databases), and I am looking for a way to temporarily lock out our developers (they have data reader access) to keep my results cleaner.
Any suggestions?
The server needs to be available to Reporting Services (i.e. the business users) for parameterized reports.
Thanks!
March 4, 2008 at 12:21 pm
Do you use windows authentication? If so, all of your developers should be in a group. You could disable the login for that group.
Personally, I would have offloaded the tuning on a test or dev server and saved the recommendations. DTA can pull the needed metadata and statistics from the production database, without copying the data over.
more info:
March 4, 2008 at 12:25 pm
better link:
March 4, 2008 at 3:57 pm
Well, if u want to go that route, you could come in extra early and put all those DBs in read-only mode :), but I'd go with the first advice you got and just block the whole user group all the users should be tied to.
March 4, 2008 at 11:49 pm
Set the database into restricted mode. Means that only sysadmn and db_owner can connect to it.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply