SQL Server Performance

DTA Compatibility

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Luis Martin, Jun 12, 2007.

  1. Luis Martin Moderator

    I was runing a single query testing DTA, tha's what I find:

    1) Using sql 2000 sp4 never ends.
    2) Using sql 2005 sp2 works fine.

    Both instances are in the same server with Windows 2003.

    I already post this problem in Microsoft forum.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  2. satya Moderator

    Anyway this relates to SQL 2008 CTP?

    I believe there is a compatibility issue with DTA working against SQL 2000 instance, hope that instance is patched upto the latest SP & hotfixes.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. Luis Martin Moderator

    What was my mistake?.

    Same moving was done in Microsoft Forum.

    I'm talking about DTA SQL 2008 CTP.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  4. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] You haven't mentioned in your post and even in my reply, hence the move is there.<br />I'm moving back to SQL2008 section...<br /><br />I believe the compatibility features for SQL 2008 against 2000 will be limited and in this case the DTA will allow upto 2005. I feel SQL 2008 CTP is also new and you might check same again after 2 CTP releases again.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  5. Luis Martin Moderator

    Thanks Satya.

    BTW: All the others tools works fine with 2000.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  6. satya Moderator

    Soon the new stuff for SQL 2005 will not have any compatibility or limited compatibility for 2000 as the support will end by April 2008.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  7. Luis Martin Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Soon the new stuff for SQL 2005 will not have any compatibility or limited compatibility for 2000 as the support will end by April 2008.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Well I'm @#$%^&*$$ dead.[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All in Love is Fair <br />Stevie Wonder<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  8. satya Moderator

    Get more business by referring or forcing [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] your clients to upgrade SQL 2005.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
  9. Luis Martin Moderator

    There is no problem with my clients, the problem is the Company who developer the applications. Still don't work with 2005.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  10. satya Moderator

    I think its chicken & egg situation, if clients are demanding for upto date components then the vendors must work it out.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page