solving sql server problems for millions of dbas and developers since 2006

SQL Product Highlight

Red Gate Software - SQL Monitor

SQL Server performance monitoring and alerting - SQL Monitor offers an easy entrance to advanced server monitoring with a simple design that's a refreshing change from the status quo. Red Gate have added custom metrics and user roles to the product without spoiling its ease-of-use, to help you answer that timeless question, 'How healthy are your servers?'

Learn more!

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)

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

Sponsor Information

Try the award winning SQL diagnostic manager as a free 14-day trial!

It takes just 5 minutes to connect your SQL Databases to source control. Got 5 minutes? Get started now.

Need SQL Server help and not sure where to turn? Reach out to the Edgewood consultants for a Health Check.

Get SQL Server Tips Straight from Kevin Kline.

Join the over million SQL Server Professionals who get their issues resolved daily.

Learn SQL Server 2012, Performance Tuning, Development, Administration, Replication and more - free webcasts