SQLServerCentral.com / Administering / SQL Server 2005 / One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggest / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 08:55:58 GMT20RE: One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggesthttp://www.sqlservercentral.com/Forums/Topic1392342-146-1.aspxAnthony its happening with all queries and indexing i am not sure when it was done..Tue, 04 Dec 2012 08:32:47 GMTsqlpantherRE: One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggesthttp://www.sqlservercentral.com/Forums/Topic1392342-146-1.aspxYes Sanket same hardware configuration same number of databases in same domain..Tue, 04 Dec 2012 08:30:55 GMTsqlpantherRE: One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggesthttp://www.sqlservercentral.com/Forums/Topic1392342-146-1.aspxis it every query or just certain queriesdo you do index and statistic maintenance on all your databasesTue, 04 Dec 2012 06:00:10 GMTanthony.greenRE: One sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggesthttp://www.sqlservercentral.com/Forums/Topic1392342-146-1.aspx1)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 neededTue, 04 Dec 2012 05:50:38 GMTsanket kokaneOne sql sevrer 05 runs fine in UAt other runs slow ni Dev--Please suggesthttp://www.sqlservercentral.com/Forums/Topic1392342-146-1.aspxhello 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 ALLTue, 04 Dec 2012 03:53:31 GMTsqlpanther