One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggest

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » One sql sevrer 05 runs fine in UAt other runs...

One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggest

Rate Topic

Display Mode

Topic Options

Author

Message

sqlpanther

Posted Tuesday, December 04, 2012 3:53 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 12:19 AM
Points: 26, Visits: 131

hello All,
i have 2 sql server 05 in 2 diff environment one in UAt and One in DEV theone server in UAT environment is running slow all the time irrespective of any querry running in it ..and the other in DEV environment is just fine..can someone please suggest me what are the possible reasons to it and what steps shall i take to resolve this issue..

Thanks ALL

Post #1392342

sanket kokane

Posted Tuesday, December 04, 2012 5:50 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 5:04 AM
Points: 323, Visits: 966

1)Are the hardware,memory configuration of the both the servers are same ?
2)do you have same copy of databases on each server.

may be more information needed

-----------------------------------------------------------------------------
संकेत कोकणे

Post #1392400

anthony.green

Posted Tuesday, December 04, 2012 6:00 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

is it every query or just certain queries

do you do index and statistic maintenance on all your databases

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1392405

sqlpanther

Posted Tuesday, December 04, 2012 8:30 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 12:19 AM
Points: 26, Visits: 131

Yes Sanket same hardware configuration same number of databases in same domain..

Post #1392537

sqlpanther

Posted Tuesday, December 04, 2012 8:32 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 12:19 AM
Points: 26, Visits: 131

Anthony its happening with all queries and indexing i am not sure when it was done..

Post #1392544

« Prev Topic | Next Topic »

Permissions