Forum Replies Created

Viewing 15 posts - 511 through 525 (of 758 total)

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    GilaMonster (7/12/2012)

    From os_wait_stats, no, that's the aggregated totals since SQL started.

    For process level, sys.dm_os_waiting_tasks or extended events

    Thanks

    Is sys.dm_os_waiting_tasks current tasks or also tasks that have waited?

    Thanks

    July 12, 2012 at 8:58 am

    #1512124

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    GilaMonster (7/12/2012)

    SQLSACT (7/12/2012)

    So this is saying that a process wanted to acquire a Shared Lock on an object but something else already had an exclusive lock on the same object?

    Not...

    July 12, 2012 at 8:36 am

    #1512108

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    GilaMonster (7/11/2012)

    It's the type of the wait in all cases.

    When a process has to wait for a resource, it gets a matching wait type (waiting for locks gets a lock...

    July 12, 2012 at 8:22 am

    #1512090

  • RE: Last Full and Log backup

    GilaMonster (7/11/2012)

    SELECT database_name ,

    MAX(CASE type

    WHEN 'D' THEN...

    July 12, 2012 at 7:01 am

    #1512028

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    GilaMonster (7/11/2012)

    SQLSACT (7/11/2012)

    Hi All

    A question regarding the following DMV:

    sys.dm_os_wait_stats

    Does this DMV indicate processes that are currently in a waiting state or processes that have had to wait for resources?

    That is...

    July 11, 2012 at 11:46 am

    #1511711

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    Grant Fritchey (7/11/2012)

    The single best source for understanding how to deal with wait states is this excellent white paper from Microsoft. It should answer most of your questions in detail.

    In...

    July 11, 2012 at 7:57 am

    #1511550

  • RE: Last Full and Log backup

    GilaMonster (7/11/2012)

    SELECT database_name ,

    MAX(CASE type

    WHEN 'D' THEN...

    July 11, 2012 at 1:43 am

    #1511369

  • RE: Index Fragmentation - Scans/Seeks

    GilaMonster (7/7/2012)

    It's sometimes called that, I personally hate the term because it's ambiguous.

    It's low average page density.

    If I find that my Index does have a Low Average Page Density,

    Can I...

    July 7, 2012 at 11:58 am

    #1510003

  • RE: Index Fragmentation - Scans/Seeks

    GilaMonster (7/7/2012)

    It's sometimes called that, I personally hate the term because it's ambiguous.

    It's low average page density.

    Thanks

    July 7, 2012 at 11:40 am

    #1509998

  • RE: Index Fragmentation - Scans/Seeks

    GilaMonster (7/7/2012)

    Maybe.

    It's not just about the effect on scans, it's also about the page density. If that's lower than desired, the index takes more space than it otherwise needs and...

    July 7, 2012 at 10:28 am

    #1509991

  • RE: Backup/Restore

    Sqlsavy (7/6/2012)

    All transaction log backups taken after the full database backup should be restored . Log backups running prior /while full database backups should be ignored.If you try to restore...

    July 6, 2012 at 4:23 am

    #1509582

  • RE: Backup/Restore

    Sqlsavy (7/6/2012)

    Backups must be restored in the order in which they were created. Before you can restore a particular transaction log backup, you must first restore the following previous backups...

    July 6, 2012 at 4:11 am

    #1509567

  • RE: SQL Single Node Cluster - Name Change

    Perry Whittle (6/13/2012)

    based on this......

    SQLSACT (6/12/2012)

    This is where we are

    Forget about Server3 - Doesn't exist

    We have a 2 Node Cluster with servers Server1 & Server2

    In a different geographic location (on...

    June 13, 2012 at 1:34 am

    #1500182

  • RE: SQL Single Node Cluster - Name Change

    Perry Whittle (6/12/2012)

    sorry still not with you

    OK

    This is where we are

    Forget about Server3 - Doesn't exist

    We have a 2 Node Cluster with servers Server1 & Server2

    In a different geographic location...

    June 12, 2012 at 8:42 am

    #1499835

  • RE: SQL Single Node Cluster - Name Change

    Perry Whittle (6/12/2012)

    sorry still not with you

    Ok

    So we have Server1 & Server2 - Together as a 2 Node Cluster

    Server3 - Single Node Cluster, different storage and geographic location

    Server2 needs to...

    June 12, 2012 at 7:31 am

    #1499794

Viewing 15 posts - 511 through 525 (of 758 total)