solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips
















   Got a SQL tip?
            We want to know!



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






Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | today's tip | first timer?
Some names and products listed are the registered trademarks of their respective owners.