Post reply

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

  • December 4, 2012 at 3:53 am

    #265729

    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

  • December 4, 2012 at 5:50 am

    #1565248

    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

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

  • December 4, 2012 at 6:00 am

    #1565251

    is it every query or just certain queries

    do you do index and statistic maintenance on all your databases

  • December 4, 2012 at 8:30 am

    #1565366

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

  • December 4, 2012 at 8:32 am

    #1565371

    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