Post reply

CPU utilization is 100%

  • July 29, 2011 at 6:59 am

    #1360737

    Let's call mine plain luck.

    The servername (@@servername is sql server) was the same.

    Physical machine name / network name / SQL instance were all different.

    I once had a network admin copy a VM and NOT stop the old one before bringing the new one online. That crashed the prod server (ip conflict or something like that)

  • July 29, 2011 at 7:06 am

    #1360751

    Lavanyasri (7/29/2011)

    Hi Jeff,

    So is it compulsory to change the server name ??

    My admin says it's a really bad idea and so does our consultant.

  • July 29, 2011 at 7:11 am

    #1360760

    Thanks a lot to jeff and ninja ......

  • July 29, 2011 at 8:57 am

    #1360855

    AFAIK, having duplicate FQDNs on a domain is not allowed. You could potentially have duplicate host names on separate domains, but the resolution on the Windows side should be fine. If you have duplicate Windows names, you should get errors thrown on the DCs and on the two hosts.

    SQL uses the Windows host name as part of it's connection mechanism if you connect by name. If you connect by IP, you might never notice there being a problem if you only query inside a database.

  • July 29, 2011 at 1:14 pm

    #1361056

    Steve Jones - SSC Editor (7/29/2011)

    AFAIK, having duplicate FQDNs on a domain is not allowed. You could potentially have duplicate host names on separate domains, but the resolution on the Windows side should be fine. If you have duplicate Windows names, you should get errors thrown on the DCs and on the two hosts.

    SQL uses the Windows host name as part of it's connection mechanism if you connect by name. If you connect by IP, you might never notice there being a problem if you only query inside a database.

    I could see depending on what exactly was 'cloned' you might want to check for duplicate SPN's.

    Worth a quick check just to rule it out.

  • July 29, 2011 at 5:16 pm

    #1361165

    Very cool. Thanks for the details, folks. I appreciate it a LOT because I was just a wee bit (a lot, actually) out of my element.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 1, 2011 at 5:33 am

    #1361461

    hi ,

    How to check the two servers in the same domain or different domain ??

  • August 1, 2011 at 5:37 am

    #1361467

    Lavanyasri (8/1/2011)

    hi ,

    How to check the two servers in the same domain or different domain ??

    Asked your domain admin??

  • August 1, 2011 at 6:48 am

    #1361508

    HI Jeff ,

    I checked with my windows admin , my two servers are running in work group .

    Now its not possible to change the my SQl server name why because now the server is in live and it will effect the business .

    Please advise me ???

  • August 1, 2011 at 6:50 am

    #1361510

    AFAIK this could be done is a very small maintenance window.

    Bring the prod server offline (shut down).

    Open the other one. Rename the machine, server, @@servername. whatever you need.

    Once that's complete you should be able to brin gin the other server. I've seen that whole process done with VMWare in less than 5 minutes.

  • August 1, 2011 at 7:34 am

    #1361527

    HI ninja,

    Which one i have to change the server name is the present production server ??

  • August 1, 2011 at 7:36 am

    #1361530

    The one which is NOT the real prod server.

  • August 1, 2011 at 8:56 am

    #1361616

    Ninja's_RGR'us (7/29/2011)

    Lavanyasri (7/29/2011)

    Hi Jeff,

    So is it compulsory to change the server name ??

    My admin says it's a really bad idea and so does our consultant.

    Really late to the game, but I wanted to chip in with total agreement. The one exception I can think of is if one of the servers is a cold standby or completely shut off until a DR situation arises. Even then, I wouldn't be too keen on the two machines being the same name.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 13 posts - 16 through 27 (of 27 total)

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