SQL Server Performance

SQL Server 2005 Service Pack 2

Discussion in 'Forum Announcements' started by MohammedU, Feb 19, 2007.

  1. MohammedU New Member


  2. ranjitjain New Member

    Hi Mohammed,
    Have you installed SP2 on your dev or test machine and found any new bugs?
    Or Have you noticed any performance hits etc?
    Please let me know your inputs.
  3. MohammedU New Member

    Not yet...
    I installed CTP on my laptop but not RTM...

  4. madhuottapalam New Member

    I applied SP2 on my production server and it was straight forward... one suggestion is that.. don't try to install it from Network... copy the file locally and install... from network installation there are some error reported in MSDN....

    After installation, Database engine service required to be restarted...

    I followed the below mentioned steps
    (a) Stopped all the sql server 2005 services from Configuration Manager ((i have downtime and
    i just stopped all the services as precaution)
    (b) Installed SP2
    (c) Restarted the services
    (d) SQL Server version after the installation is 9.00.3042.00


  5. alzdba Member

    I just applied sp2 on an active SQL2005 DevEdt sp1 dev server (db/as/rs) without user connections.
    Install went fine.[^] No issues in logs or sql-errorlog.
    Reboot was needed.[V]
    Install took 25 minutes for this desktop (P4) with 1Gb ram.

    Until now, no issues detected. [8D]
  6. Roji. P. Thomas New Member

    Good to see the positive responses. I am yet to see someone complaining about SP 2 installation. Guess that the product team has done a good job this time.

    Roji. P. Thomas
    SQL Server MVP
  7. satya Moderator

    Yes there were lot of suggestions, rants, fixes under Microsoft Connect site since the SP2 CTP has been released, I believe still there are lot to be fixed which are under way. There is no end of such requirement as long as the product is stable you can expect them soon.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  8. MohammedU New Member

    I came to know that SP2 has approx..4400 fixes!!!

  9. Roji. P. Thomas New Member

  10. alzdba Member

    I've implemented 5 (dev/QA) sql2005 StdEdtn sp1 to sp2 without any issues until now.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />I've also implemented it for a clustered X64 EE test instance without an issue. The plant was not running production today, it was planned downtime. The other 3 (prod) instances were up and running, but offcourse without connections because we took e.g. biztalk offline. Just in case [^]<br /><br />The upgrade went very smooth [8D] and took +- 35 minutes to complete (for both nodes).<br />It is very strange. Unlike with the original install, where you could also follow the install at the second node, now it just states it is waiting for the install on the second node to complete. Eventvwr and the installlogs are the place to be.<br /><br />Fingers crossed [|)]<br /><br />btw: I 've tried to avoid reboots on the dev-servers, shutting off all services the "inventory" showed, still it needed a reboot for one the XML installation. [?][?]
  11. satya Moderator

  12. MohammedU New Member

    I came to know that Microsoft releasing SP2 Hotfix for SQL Server 2005....

  13. MohammedU New Member

    Critical Update for SQL Server 2005 Service Pack 2 (KB:93350<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br /<a target="_blank" href=http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en>http://www.microsoft.com/downloads/details.aspx?FamilyId=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&displaylang=en</a><br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com
  14. alzdba Member

  15. alzdba Member

    No arises the question: What to do on a cluster when one instance already has SP2 ?
    - continue all instances with sp2 + the hotfix
    - continue the other instances with the refreshed sp2

  16. alzdba Member

    MS did just confirm to me that just applying the refreshed sp2 will work and will not cause issues to the allready upgraded instance. (I will have to apply the hotfix to the allready upgraded instance)
  17. alzdba Member

  18. MohammedU New Member

  19. MohammedU New Member

    Critical Update for SQL Server 2005 Service Pack 2


    Quick Details
    Version: 09.00.3159.00
    Knowledge Base (KB) Articles: KB934459
    Date Published: 4/3/2007

    In SQL Server 2005 SP2, the Maintenance Plan "Check Database Integrity" and "Execute T-SQL" Tasks can lose database context under certain circumstances. If configured to check integrity on multiple databases, the Check Integrity Task repeatedly checks the default database. If an Execute T-SQL Task contains multiple batches, separated by GO statements, and does not include USE statements in each batch, those statements that don't provide a database name will be executed against the default database. Incorrect operation can be verified by setting up a profiler trace and observing the database column.

    Elaborated a bit athttp://blogs.msdn.com/psssql/archiv...-2005-service-pack-2-sp2-fixes-explained.aspx

    Posted by alzdba


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

Share This Page