Forum Replies Created

Viewing 15 posts - 46 through 60 (of 224 total)

  • RE: SQL SERVER LOCKING ISSUES

    Setup a server side trace to identity what is causing the blocking. There are groups available for blocking in SQLserver. Hope this helps you to identify the blocking.

    -- Babu...

    December 7, 2012 at 1:52 am

    #1566492

  • RE: Simple SELECT Hang

    srphelan (11/1/2012)

    We are having an issue where a simple select statement occasionally hangs one of our applications (99% of the time it works correctly). The statement is "SELECT * from...

    November 1, 2012 at 7:39 pm

    #1555258

  • RE: Question on Lock wait types

    Thank you very much everyone.

    November 1, 2012 at 2:04 am

    #1554880

  • RE: Question on Lock wait types

    capnhector (10/29/2012)

    baabhu (10/28/2012)

    Hello Everyone,

    Our production server experiences lot of blocking and locking from application.

    I have attached the top waits from server. Can anyone help to understand or guide...

    October 30, 2012 at 11:31 am

    #1554291

  • RE: SELECT

    After long time I am attempting the question. Good tricky one !!!!.

    October 29, 2012 at 3:35 am

    #1553654

  • RE: Log file Management

    GilaMonster (10/22/2012)

    Please don't hijack other people's threads. Start your own thread with this problem.

    I am sorry. I will start a new thread on this.

    --- Babu

    October 23, 2012 at 2:30 am

    #1551776

  • RE: Log file Management

    GilaMonster (10/18/2012)

    Nothing to do with checkpoint.

    If you don't defined explicit transactions, then each and every data modification statement is wrapped in its own transaction which is automatically committed upon completion.

    So...

    October 22, 2012 at 7:23 am

    #1551369

  • RE: Qusestion on delete job

    Brandie Tarvin (10/22/2012)

    baabhu (10/20/2012)

    Brandie Tarvin (10/19/2012)

    I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?

    This is an OLTP system with tokens...

    October 22, 2012 at 7:14 am

    #1551364

  • RE: Qusestion on delete job

    Brandie Tarvin (10/19/2012)

    I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?

    This is an OLTP system with tokens needs to be...

    October 20, 2012 at 11:07 am

    #1551120

  • RE: Qusestion on delete job

    Bhuvnesh (10/19/2012)

    baabhu (10/19/2012)

    We managed to schedule it that 4 minutes job starts at odd minutes and the 10 minutes job starts at even minutes.Chances of intersecting is very rare.

    ...

    October 20, 2012 at 8:38 am

    #1551116

  • RE: Qusestion on delete job

    Grant Fritchey (10/19/2012)

    Blocking is a natural consequence of inserting and deleting data and can't be avoided. In order for the ACID properties of the transaction to be maintained, SQL Server...

    October 20, 2012 at 8:34 am

    #1551115

  • RE: While loop 2

    Damn it. Answered the question fast. Did not see the variable @b-2 is int.

    October 12, 2012 at 3:02 am

    #1548503

  • RE: move transaction log to a different drive.

    Perry Whittle (10/11/2012)

    That is correct, you cannot drop the first created (primary) data or log file . If you want to move this you will incur some minimal downtime.

    Create your...

    October 11, 2012 at 7:29 pm

    #1548409

  • RE: move transaction log to a different drive.

    MysteryJimbo (10/11/2012)

    baabhu (10/11/2012)

    MysteryJimbo (10/10/2012)

    I'd do each step in order as a precaution.

    Are you managing your transaction log with regular backups? If so, why do you say the log file...

    October 11, 2012 at 7:26 pm

    #1548408

  • RE: move transaction log to a different drive.

    MysteryJimbo (10/10/2012)

    I'd do each step in order as a precaution.

    Are you managing your transaction log with regular backups? If so, why do you say the log file is going...

    October 11, 2012 at 1:24 am

    #1547908

Viewing 15 posts - 46 through 60 (of 224 total)