Forum Replies Created

Viewing 15 posts - 23,431 through 23,445 (of 49,552 total)

  • RE: SQL Server 2008r2 : How many Log files?

    devereauxj (9/19/2011)

    Let me throw this out there. I have been running multiple logs since SQL 2000 (2003 / 1st prod instance). I have never had any errors, warnings...

    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

    September 20, 2011 at 2:40 am

    #1383670

  • RE: Dead lock issue

    Unless you had some form of trace or auditing running at the time, no.

    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

    September 20, 2011 at 2:35 am

    #1383668

  • RE: SQL Server 2008r2 : How many Log files?

    p.s. At the sizes you're talking, there's one valid reason for multiple log files. A single log file cannot be larger than 2TB. So if you're touching that, you'll need...

    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

    September 19, 2011 at 1:41 pm

    #1383466

  • RE: SQL Server 2008r2 : How many Log files?

    devereauxj (9/19/2011)

    I know, but there are 10's or hundreds of processes, SQL only writes 1 at a time to a log file. Also, I have 4 log files on...

    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

    September 19, 2011 at 1:35 pm

    #1383463

  • RE: SQL Server 2008r2 : How many Log files?

    One log file. Always and only.

    SQL does not ever parallel across log file. It writes to the log file in a serial manner. If there's more than one log file...

    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

    September 19, 2011 at 1:12 pm

    #1383455

  • RE: AWE Enabled but no gains in Memory Usage by SQL Server- Requesting Help

    32 bit or 64 bit (OS and 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

    September 19, 2011 at 11:25 am

    #1383410

  • RE: Capturing Stored Procedures statements with DMVs

    Lowell (9/19/2011)

    Based on what Jason pointed to, where you can harvest info from the execution plans, this seemed to work for me;

    i ran a proc "sp_find that takes one parameter...it's...

    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

    September 19, 2011 at 10:55 am

    #1383396

  • RE: Capturing Stored Procedures statements with DMVs

    DBCC INPUTBUFFER

    That's iirc.

    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

    September 19, 2011 at 9:50 am

    #1383373

  • RE: Index Maintenance.DBCC REINDEX fails

    dave_shipway (9/19/2011)

    I queried the sys.indexes system table and it appears that these indexes are rebuild every night by a some kind of scheduled job (which I haven't quite tracked down...

    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

    September 19, 2011 at 9:27 am

    #1383359

  • RE: sql profiler monitor page splits per sec

    Just bear in mind that's not actually page splits (in the sense of SQL splitting a full page). Any page allocations into the index get counted against that.

    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

    September 19, 2011 at 9:00 am

    #1383345

  • RE: Dead lock issue

    That's JDBC stuff, has to do with it's transaction handling.

    Nothing more that can really be said with the little you posted.

    I'd start with the app vendor (or developers if...

    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

    September 19, 2011 at 8:57 am

    #1383343

  • RE: Dead lock issue

    If you're not seeing deadlocks in the error log with that traceflag on then you aren't getting any deadlocks. That's a good thing.

    As for the error, that's not a 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

    September 19, 2011 at 8:32 am

    #1383320

  • RE: Index Maintenance.DBCC REINDEX fails

    Have you looked at the job history?

    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

    September 19, 2011 at 8:31 am

    #1383319

  • RE: Are the posted questions getting worse?

    The log doesn't have pages (it has VLFs, log blocks and log records). Checkpoint will cause the log buffer to be flushed to disk (the current set of un-hardened log...

    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

    September 19, 2011 at 8:26 am

    #1383315

  • RE: Are the posted questions getting worse?

    WayneS (9/19/2011)

    GilaMonster (9/19/2011)

    There's no good or practical reason to do what I showed, it's near-impossible to understand and it will break CheckDB. (Can't create an alternate stream of an alternate...

    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

    September 19, 2011 at 7:40 am

    #1383303

Viewing 15 posts - 23,431 through 23,445 (of 49,552 total)