Learn more about SQL Server tools

   
   



































Connect with MSSQLTips




MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Pinterest Page MSSQLTips Twitter Page MSSQLTips Google+ Page



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