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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2009-04-24 : 05:10:25
|
| Hi,I have a sqlserver thats on a dedicated staging server, thats I can't give the password to, so they cant use remote desktop and do everything they want to do.How can one efficeintly analyze and optimze the database with just sql login ? I can create trace files and pass them off to the person, can they be analyzed on a different machine ok and safely ?Thanks for any advice!mike123 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-24 : 05:19:53
|
| In the first instance it's best to concentrate on the things that are causing problems - you can get that from timings of processes. Then just look at what is happening on the server at the time and look at the query plans.That usually clears up 90% of issues in the first instance and gives a quick win.If you want it done remotely you can take a snapshot of all the queries and query plans active at a point in time on the server and send those.If it's not long running queries that are causing the issue then it's probably because it is doing row based processing or something external (like SSIS) using up memory/resources which means re-architecting.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2009-04-24 : 05:42:49
|
| Hi Nr,Not completely following you =[ What tools do you suggest I use ? Thanks again :)mike123 |
|
|
|
|
|
|
tuning a database remotely