SQL 2005 SERVER GENERATES HUGE BROADCAST

  • HI, SQL 2005 DATABSE(SP4) SERVER IS GENERATING HUGE BROADCAST & OUR ROUTERS WERE GETTING HANGED.

    The db server is used for online trading application.

    What could be the possible reason for db server to generate broadcast in network :

    Bad coding, improper patches, slammer virus(but sp4 is available)

    So what could be the sql 2005 vulnerability ?

    Please guide on above.

    vrijesh

  • vrijesh prajapati (8/14/2008)


    HI, SQL 2005 DATABSE(SP4) SERVER IS GENERATING HUGE BROADCAST & OUR ROUTERS WERE GETTING HANGED.

    First thing, please double check your version. SQL Server 2000 is up to service Pack 4, SQL Server 2005 is only at Service Pack 2.

    Please run SELECT @@Version and post the results.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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