Forum Replies Created

Viewing 15 posts - 14,686 through 14,700 (of 49,552 total)

  • RE: Trying to understand non-clustered index Fragmentation

    How many pages does the nonclustered index have?

    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

    January 22, 2013 at 11:25 am

    #1579769

  • RE: Scheduled Stored Procedure, what Database ?

    homebrew01 (1/22/2013)

    GilaMonster (1/22/2013)

    In the job step dialog, right above where the command is, is a database dropdown.

    Yes, but that is blank. I would think you need the dropdown populated, or...

    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

    January 22, 2013 at 11:12 am

    #1579761

  • RE: SQL Deadlocks

    bugg (1/22/2013)

    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...

    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

    January 22, 2013 at 9:29 am

    #1579701

  • RE: SQL Deadlocks

    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 levels

    Thanks...

    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

    January 22, 2013 at 9:06 am

    #1579690

  • RE: SQL Deadlocks

    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 a...

    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

    January 22, 2013 at 9:04 am

    #1579689

  • RE: SQL Deadlocks

    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 levels

    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

    January 22, 2013 at 8:58 am

    #1579681

  • RE: Scheduled Stored Procedure, what Database ?

    In the job step dialog, right above where the command is, is a database dropdown.

    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

    January 22, 2013 at 8:50 am

    #1579676

  • RE: Lock Pages in Memory setting for 64-bit systems

    surilds (1/22/2013)

    Results after executing DMV "sys.dm_os_process_memory"

    physical_memory_in_use_kb = 93631444 KB

    locked_page_allocations_kb = 92303888 KB

    Does it mean 92303888 KB is locked for OS?

    No. That DMV measure's SQL's memory usage.

    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

    January 22, 2013 at 7:02 am

    #1579618

  • RE: Lock Pages in Memory setting for 64-bit systems

    surilds (1/22/2013)

    The counter's graph is near to 100%

    Total server memory is not measured in %, it's measured in KB

    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

    January 22, 2013 at 7:02 am

    #1579617

  • RE: Lock Pages in Memory setting for 64-bit systems

    Total server memory. It's a SQL counter.

    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

    January 22, 2013 at 6:07 am

    #1579591

  • RE: PLE (Page life expectancy).

    ben.brugman (1/22/2013)

    CheckDB effectively destroys the cache. (Why?).

    Because it reads every single allocated page in the database and, like all other operations, reads them through the buffer pool. Unless you happen...

    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

    January 22, 2013 at 5:28 am

    #1579574

  • RE: Lock Pages in Memory setting for 64-bit systems

    Don't use Task Manager to check SQL's memory usage. It can report a completely incorrect figure. Use perfmon.

    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

    January 22, 2013 at 5:23 am

    #1579571

  • RE: SCAN count + OR Strategy

    karthik M (1/22/2013)

    #1)

    Logical Read : 20

    #2)

    Logical Read:2

    which one is better? Less Logical Read. But it uses "Table Scan". Again I think as the table record is very less, it...

    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

    January 22, 2013 at 3:18 am

    #1579506

  • RE: Detect missing indexes

    You don't create indexes just based on that. The missing index DMV are suggestions, nothing more. Create an index on a test server, run a representative load, see if the...

    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

    January 22, 2013 at 1:37 am

    #1579483

  • RE: SCAN count + OR Strategy

    karthik M (1/21/2013)

    All,

    I found some wierd thing today when i ran the below two

    version of queries.

    select * from sub_fund

    where sub_fund_id in (1,2,3,4,5,6,7,8,9,10)

    scan count = 10

    select * from sub_fund

    where sub_fund_id in...

    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

    January 22, 2013 at 1:33 am

    #1579480

Viewing 15 posts - 14,686 through 14,700 (of 49,552 total)