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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2007-12-04 : 07:13:16
|
| In my new role I am about to be given access to some SQL servers. I have a checklist of things that I intend to go through, this includes things like looking at indices etc. I know that some of the servers hold things like Microsoft Content Manager and other legacy systems, in fact I think that only one of the servers will hold databases developed in house.My question is - for these legacy systems, is there any reason why I should not do some performance tuning and/or index tuning etc if it seems to be required? MCMS in particular is very new to me and so I am not really sure what I can (or cannot) get away with. I seriously doubt that anyone will have done anything like this since the systems were initially setup, in fact they are all likely to still be on their default settings.thankssteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-12-04 : 08:27:48
|
| There can be issues with adding indexes. It can cause other processes to slow down and cause blocking and deadlocks.Also some things might rely on the order that data is returned and adding and index can upset that (it shouldn't and will probably have problems at some point anyway but I've seen it happen).Only way to find out is to try it and see.If your systems aren't having problems I would leave it alone. No point in tinkering if you aren't get to get much benefit for the risk.==========================================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. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-04 : 22:53:29
|
| For those third party app's db, change anything in it violates license agreement. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-12-05 : 08:50:53
|
OK thanks for your input guys, much appreciated. quote:
If your systems aren't having problems I would leave it alone. No point in tinkering if you aren't get to get much benefit for the risk.
I can see the wisdom in this and in my defence I did say "if it seems to be required". From what I have discovered since my post the only database that is having serious performance issues is one that was developed in house, so I can at least address that. I suspect that there are no indices at all on it or that all the data from tables is pulled down the wire as it is only accessed from an MS Access client using ODBC.thanks againsteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-05 : 08:59:18
|
You could try PASSTHROUGH queries and let SQL Server do all processing, instead of MS Access.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-12-07 : 09:26:13
|
| Thanks Peso I'll take a look into that, in this particular case we may be able to setup stored procedures and views as this app is still supported in house.steve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
|
|
|
legacy system admin