User Logins fails when reaching 1600

  • Hi All

    I need help, we are busy with load testing on our VM environment but from the load runner simulating an assessment once we reach 1600 user logins the whole thing bombs out

    SQL Server (2008 Ent 64bit, 8 CPU’s and 60GB RAM, OS 2008R2 Ent 64bit) Web Server (4 CPU’s, 8GB RAM & OS 2008R2 Ent) but the trick here is Production works fine now QA giving issues. I looked at MARS feature will it be beneficial to use in this case?

    Thnx

    It's better to fail while trying, rather than fail without trying!!!

  • Bombs out with what errors?

    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
  • Hi

    As soon as the 1600 user logs in the web page stops rendering but de resources on de db is ok. No error the page nolonger renders

    It's better to fail while trying, rather than fail without trying!!!

  • If the web page stops rendering but SQL's OK, I would be looking at IIS (or whatever your web server is), not SQL.

    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
  • Thx Gila, I found de problem it was on how our QA DMZ setup to limit connections to 2000

    It's better to fail while trying, rather than fail without trying!!!

Viewing 5 posts - 1 through 4 (of 4 total)

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