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

  • 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

  • 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

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

  • is it every query or just certain queries

    do you do index and statistic maintenance on all your databases

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

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply