Learn more about SQL Server tools

   
   



















































How to speed up my server

Asked 2/21/2012 9:55:04 AM by MMM Shukri

Dear Sir,
we are running 7 different databases in on server [Server configuration Intel Xeon 2.53Ghz]. databases sizes are following

 

Name Db_Size
A 181.94 MB
B 70.50 MB
D 60138.00 MB
E 156.44 MB
F 4369.38 MB
G 156281.13 MB
H 434.19 MB

 

My question is when doing a single process [update,select] in database G always getting struck database D. so did index in database G but no feel any performance different. Hard disk spaces also available. so dear sir please give me the better solution to that.

Thanking you

MMM Shukri.



Answered 3/27/2012 9:40:29 AM by Balaji (0) vote answer is useful vote answer is NOT useful

Hi Shukri,

1) You may have some stored procedure with linked tables... which may not be indexed... please review your Database G in stored procedure & try to create index on DB D.

2) Otherwise your query may have more Alias r more joins which may cause slow performance in Database.. Pls review your qurey....

3) Otherwise check for your SQL Locks & Physical design of your database... sometimes improper physical db design also slowdown your DB....

Hope these will help....

Balaji



Post an Answer

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email   Notify for updates
Comments
*Enter Code refresh code


 
Sponsor Information






 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Free T-shirt

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.