Forum Replies Created

Viewing 15 posts - 166 through 180 (of 220 total)

  • RE: SQL Server 2012 licensing

    up to 30 individual users

    February 4, 2013 at 7:54 am

    #1583964

  • RE: SQL Server 2012 licensing

    anthony.green (2/4/2013)

    As with any thing licensing, speak to MS or your MS reseller directly, dont take a public forum as the truth on something as important as licensing as MS...

    February 4, 2013 at 7:46 am

    #1583954

  • RE: High page splits/sec

    GilaMonster (2/1/2013)

    Page splits are caused by inserts into the middle of indexes and updates that grow the row, nothing else. They're internal to SQL.

    As for thresholds, take them with a...

    February 1, 2013 at 7:38 am

    #1583451

  • RE: High page splits/sec

    GilaMonster (2/1/2013)

    Sure, often a lot higher that what you have there.

    Hi Gila,

    I read somewhere that page splits/sec should not be more then 20% of the batch requests/sec, mine are...

    February 1, 2013 at 6:13 am

    #1583408

  • RE: High page splits/sec

    Anyone else had high page splits?

    Thanks

    February 1, 2013 at 5:27 am

    #1583381

  • RE: High page splits/sec

    Hi, most of the time im using 90 sometimes 0

    January 31, 2013 at 3:54 pm

    #1583219

  • RE: High page splits/sec

    Not using guids, we are using identity columns

    January 31, 2013 at 2:07 pm

    #1583183

  • RE: SQL Deadlocks

    GilaMonster (1/23/2013)

    That's a whole lot of fairly useless indexes. 🙁

    🙁 why do you say that? Could you recommend better ones? thanks

    January 23, 2013 at 9:12 am

    #1580159

  • RE: SQL Deadlocks

    GilaMonster (1/23/2013)

    Can you post the table definition and all index definitions for dbo.order?

    Just spotted there are 2 indexes on session_id I will drop one of them.

    CREATE TABLE [dbo].[order](

    [rsn] [bigint] IDENTITY(1,1)...

    January 23, 2013 at 8:36 am

    #1580128

  • RE: SQL Deadlocks

    anthony.green (1/23/2013)

    All statistics and indexes rebuilt and updated on the order table?

    Can you post the execution plans as a SQLPLAN file from the below query, if they exist any more.

    select...

    January 23, 2013 at 8:22 am

    #1580119

  • RE: SQL Deadlocks

    GilaMonster (1/23/2013)

    bugg (1/23/2013)

    Hi Anthony, I don't have any deadlock XML in my error log but i do have the information above just broken up into lines.

    That's a deadlock graph. 2...

    January 23, 2013 at 6:32 am

    #1580046

  • RE: SQL Deadlocks

    anthony.green (1/23/2013)

    Do you have the deadlock XML in the error log, should be many many lines that looks like this

    <TextData><deadlock-list>

    <deadlock victim="process53b9288">

    <process-list>

    <process id="process53b9288" taskpriority="0" logused="476"...

    January 23, 2013 at 2:34 am

    #1579960

  • RE: SQL Deadlocks

    anthony.green (1/22/2013)

    Do you have traceflag 1222 enabled?

    If so can you post the deadlock graph from the error log

    If not run

    DBCC TRACEON (1222, -1)

    and then post the graphs once a deadlock...

    January 22, 2013 at 11:50 am

    #1579780

  • RE: SQL Deadlocks

    GilaMonster (1/22/2013)

    bugg (1/22/2013)

    GilaMonster (1/22/2013)

    bugg (1/22/2013)

    Any insight into dealing with deadlocks would be greatly appreciated.

    In general:

    Optimise the queries. If that doesn't fix the problem use one of the row versioning-based isolation...

    January 22, 2013 at 9:24 am

    #1579699

  • RE: SQL Deadlocks

    GilaMonster (1/22/2013)

    bugg (1/22/2013)

    anthony.green (1/22/2013)

    Do you have traceflag 1222 enabled?

    If so can you post the deadlock graph from the error log

    If not run

    DBCC TRACEON (1222, -1)

    and then post the graphs once...

    January 22, 2013 at 9:21 am

    #1579697

Viewing 15 posts - 166 through 180 (of 220 total)