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....


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
*Enter Code refresh code

Sponsor Information