Forum Replies Created

Viewing 15 posts - 256 through 270 (of 1,518 total)

  • RE: Query to capture currently executing long-time queries

    Perry Whittle (7/23/2011)

    Marios Philippopoulos (7/22/2011)

    It looks like I am not able to capture the sproc name in the [executing batch] column if the individual SQL statement is submitted as dynamic...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 25, 2011 at 7:49 am

    #1357777

  • RE: Query to capture currently executing long-time queries

    Chuck Hottle (7/22/2011)

    That's one way to do this, but I'd probably opt for a server-side trace with a duration filter and then import those into a table for analysis. A...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 22, 2011 at 1:51 pm

    #1357284

  • RE: Query to capture currently executing long-time queries

    It looks like I am not able to capture the sproc name in the [executing batch] column if the individual SQL statement is submitted as dynamic SQL.

    All I get is...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 22, 2011 at 12:35 pm

    #1357238

  • RE: Query to capture currently executing long-time queries

    Chris Harshman (7/22/2011)

    I think it looks pretty good. In my query I use for simmilar purposes, I do a couple extra joins:

    INNER JOIN sys.dm_exec_sessions s ON r.session_id = s.session_id

    LEFT...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 22, 2011 at 10:49 am

    #1357187

  • RE: Identifying long running queries SQL server

    GilaMonster (7/21/2011)

    Please note: 3 year old thread.

    I'll open a new post.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 22, 2011 at 8:19 am

    #1357076

  • RE: Identifying long running queries SQL server

    Would the query below work?

    I'm looking for long-running queries that are currently running on the server, not a historic analysis of those stored in the cache.

    Queries are ordered by...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 21, 2011 at 1:22 pm

    #1356689

  • RE: Script needed to retrieve database-role mappings of server login, including nested-role mappings if any - sp_helprolemember does not return implicit mappings

    Perry Whittle (7/18/2011)

    are you aiming at just user created database roles or fixed roles too?

    Both.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 18, 2011 at 9:34 am

    #1354300

  • RE: Script needed to retrieve database-role mappings of server login, including nested-role mappings if any - sp_helprolemember does not return implicit mappings

    What you wrote earlier makes sense. I'm using this comparison in a production vs. D/R environment analysis of settings.

    When a DBA attempts to synchronize D/R role mappings according to production...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 18, 2011 at 9:33 am

    #1354299

  • RE: Script needed to retrieve database-role mappings of server login, including nested-role mappings if any - sp_helprolemember does not return implicit mappings

    Any input anyone?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 18, 2011 at 8:29 am

    #1354259

  • RE: SQL Server Memory usage

    Where do the warnings come from?

    Can you also provide the actual message?

    Also, assuming you are on a physical (not virtual server) what is the Available Memory In Task Manager?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 5, 2011 at 2:14 pm

    #1348571

  • RE: powershell WMI error: "Could not obtain SQL Server Service information. An attempt to connect to WMI ... failed with the following error: access is denied."

    For sure.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    June 21, 2011 at 9:31 am

    #1341917

  • RE: powershell WMI error: "Could not obtain SQL Server Service information. An attempt to connect to WMI ... failed with the following error: access is denied."

    opc.three (6/21/2011)

    Please have a look at this MSDN forum post. It references an MSDN article related to SSIS but see the section "Eliminating the "Access Is Denied" Error. The original...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    June 21, 2011 at 9:27 am

    #1341914

  • RE: powershell WMI error: "Could not obtain SQL Server Service information. An attempt to connect to WMI ... failed with the following error: access is denied."

    opc.three (6/20/2011)

    What version is the OS is running on the remote server? What version is the database instance?

    Thank you for responding.

    OS is on Windows 2003 R2, SP2

    sql is on SQL...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    June 21, 2011 at 9:09 am

    #1341905

  • RE: Need to script out report subscriptions

    I actually found a link that is quite relevant to what I am trying to do, which is to script out all report subscriptions and non-default execution settings and redeploy...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    June 20, 2011 at 8:44 am

    #1341240

  • RE: Need query of ReportServer database that retrieves report-specific security information

    quan23 (6/20/2011)

    The security policy of all reports/folders is stored in the PolicyID field in the catalog table of the ReportServer database

    The PolicyRoot field in the catalog table defines whether an...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    June 20, 2011 at 7:58 am

    #1341205

Viewing 15 posts - 256 through 270 (of 1,518 total)