Help Tuning My Server (Trust Issues, Security, etc)
Posted on 2005-05-10
I’ve always been my own DBA. I’m now having problems with near 100% CPU usage (and often 100% CPU usage). I'm thinking of bringing on a consultant to help tune the server a bit better than I have been able to do myself. However I have a few concerns and questions:
1.) To allow someone to use the SQL Profileer, I have to give them full DB access, right? What should I do shy of giving them sa access?
2.) What steps can I take to minimize data theft, minimize the DBA’s access to our server after the project is completed, etc?
3.) Should there be concern about getting such help, or am I just thinking about the negatives too much?
Thanks for your opinions!