Results 1 to 5 of 5

Thread: Load testing sqlexpress

  1. Dec 9th, 2008, 04:30 AM #1
    venerable bede
    venerable bede is offline

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018

    Load testing sqlexpress

    Does anyone know of a way I can load test an installation of sqlexpress 2005 ?

    I have a number of installs out there and am having issues with express. It seems to be getting stuck in the middle of a transaction and jamming up causing complete failure of my application.

    Its an unusual problem.
    The db only throws this problem up after a while. Its as if its building up crap

    Any techniques or tools would be much appreciated.

    Thanks All

    Parksie
    Reply With Quote Reply With Quote
  2. Dec 9th, 2008, 04:46 AM #2
    gsprasanna81
    gsprasanna81 is offline
    Junior Member
    Join Date
    Oct 2008
    Posts
    22

    Re: Load testing sqlexpress

    Try to Install

    Visual Studio Service Pack 1 (SP1)

    Before that install vs Sp1

    Install VS Preparation Tool

    It will Remove un wanted Patch HOTFix files.

    Then Install SQLEXPRESS 2005/2008
    http://dotnetcbt.blogspot.com/
    Reply With Quote Reply With Quote
  3. Dec 9th, 2008, 05:39 AM #3
    venerable bede
    venerable bede is offline

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018

    Re: Load testing sqlexpress

    I'm a bit confused.
    As far as I know I have all that installed.

    Parksie
    Reply With Quote Reply With Quote
  4. Dec 9th, 2008, 05:57 AM #4
    gsprasanna81
    gsprasanna81 is offline
    Junior Member
    Join Date
    Oct 2008
    Posts
    22

    Re: Load testing sqlexpress

    Ok

    When you installation time , Which Step its going to hang?
    http://dotnetcbt.blogspot.com/
    Reply With Quote Reply With Quote
  6. Dec 9th, 2008, 08:15 AM #5
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Load testing sqlexpress

    It's not getting stuck during install...

    It's getting stuck in a transaction - while users are accessing the database - right?

    Can you get onto the network while this "hanging" is occuring?

    Open a query window - EXEC SP_WHO or EXEC SP_WHO2 - this will tell you who is deadlocking the database.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width