Here is the email he sent back to me if anyone wants to throw in, haven't said anything myself yet.
Thanks for your response,since i am a new user and i made a survy in many other sites but information was not sufficent.
We are developing software product for Health care sector, usually database sizes varies from various sites depending upon the patient flow usually it ranges from 2GB to 60GB,there are generally 100 to 150 concureent users using our applications across 30 to 40 sites,our database is built upon SQL 7.0 and applications on VB 6.0.
Now we are facing lot of performance related problem and we want information on following topics:
1.Performance tool, i heared about LOAD RUNNER, basically we need tool which should tell how many transactions are passing (how many writes and reads)on tables happens and how much each transaction takes time.
2.In order to improve performance of database, i ve thought on some guide lines, such as
a.Optimizing the Row space
b.Defining Indexes(where ever necessary as per our database design)
c.Defining the Primary keys(where ever necessary as per our database design)
d.Handling the transaction preferably by Stored procedure.
Well these are above points where i need exactly some information, if you have any information on this or any web site address kindly let me know.
Thanks and Regards,
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)