Forum Replies Created

Viewing 15 posts - 796 through 810 (of 1,518 total)

  • RE: SQL Server Agent failure - service restarted on its own!

    DBADave (12/29/2008)

    My 32-bit cluster is running 2005 SP1 and my 64-bit cluster is running 2005 SP2. Both are Enterprise Edition. We plan on calling Microsoft in January to...

    __________________________________________________________________________________
    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]

    December 29, 2008 at 1:14 pm

    #918585

  • RE: SQL Server Agent failure - service restarted on its own!

    DBADave (12/29/2008)

    I'm having the same problem and can't find the cause. It started this month on two of our SQL clusters. One cluster is 32-bit and the...

    __________________________________________________________________________________
    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]

    December 29, 2008 at 1:03 pm

    #918574

  • RE: SQL Server Agent failure - service restarted on its own!

    Nicholas Cain (12/29/2008)

    Might have to chalk that one up to the SQL gremlins, unless someone else has any ideas

    Yeah, probably the ghost of Christmas past... 😉

    Hopefully it's a one-of...

    __________________________________________________________________________________
    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]

    December 29, 2008 at 12:42 pm

    #918558

  • RE: SQL Server Agent failure - service restarted on its own!

    Nicholas Cain (12/29/2008)

    That is totally random.

    And nothing in the .2 log that indicates anything I expect.

    Nothing in the SQL logs either?

    No, there is nothing in the .2 log or 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]

    December 29, 2008 at 12:37 pm

    #918555

  • RE: SQL Server Agent failure - service restarted on its own!

    Nicholas Cain (12/29/2008)

    Anything in the SQLAGENT.1 log?

    Are there any stack dumps sitting in the same folder?

    Take a look through those would be your best bet.

    Funny thing is, there is no...

    __________________________________________________________________________________
    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]

    December 29, 2008 at 12:28 pm

    #918546

  • RE: Questions regarding utilization of the MTL area by the SQL CLR

    Jonathan Kehayias (12/23/2008)

    It won't be a leak. When a backup is running, query the sys.dm_exec_requests DMV and find the session_id that it is running on. Then query the...

    __________________________________________________________________________________
    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]

    December 23, 2008 at 9:27 am

    #916860

  • RE: Questions regarding utilization of the MTL area by the SQL CLR

    Jonathan Kehayias (12/23/2008)

    Watch your Error Log for the next few weeks and see if you experience App Domain Unloads due to memory pressure. If you get one or two...

    __________________________________________________________________________________
    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]

    December 23, 2008 at 9:14 am

    #916848

  • RE: Questions regarding utilization of the MTL area by the SQL CLR

    Is a server reboot necessary after the -g384 parameter is added, or is an instance restart sufficient for the change to take effect?

    __________________________________________________________________________________
    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]

    December 23, 2008 at 9:05 am

    #916838

  • RE: Questions regarding utilization of the MTL area by the SQL CLR

    Jonathan Kehayias (12/22/2008)

    My numbers in testing seem to line up with what you are seeing. Change the last query out to be:

    SELECT

    CAST(Size AS BIGINT)/1024 AS [Free size, KB]...

    __________________________________________________________________________________
    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]

    December 23, 2008 at 7:29 am

    #916752

  • RE: Questions regarding utilization of the MTL area by the SQL CLR

    Here is also a related question that I missed asking in my OP.

    The -g384 parameter had an effect only on the Total avail mem, KB value and not the Max...

    __________________________________________________________________________________
    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]

    December 22, 2008 at 2:17 pm

    #916408

  • RE: Questions regarding utilization of the MTL area by the SQL CLR

    Jonathan Kehayias (12/22/2008)

    You really need to goto x64. I can certainly understand that might not be an option, but for what you are trying to do x64 is so...

    __________________________________________________________________________________
    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]

    December 22, 2008 at 2:03 pm

    #916394

  • RE: Questions regarding utilization of the MTL area by the SQL CLR

    Jonathan, thanks for the response, I was hoping you would! 🙂

    In my environment we have 8 GB of RAM (32-bit OS).

    3-gb and PAE switches enabled.

    2 SQL db-engine instances and...

    __________________________________________________________________________________
    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]

    December 22, 2008 at 1:48 pm

    #916382

  • RE: Configure memory for Integration Services service and monitor current use of memory by SSIS

    CozyRoc (12/19/2008)

    There is no place where you specify global limit for SSIS processes. You control memory consumption granulary, by controlling specific SSIS tasks memory constraints. A good example is the...

    __________________________________________________________________________________
    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]

    December 19, 2008 at 10:50 am

    #915502

  • RE: Configure memory for Integration Services service and monitor current use of memory by SSIS

    CozyRoc (12/19/2008)

    This is unusual question, Marios. Why would you want to know how much memory is consumed by the SSIS service? Do you have an issue in particular?

    I don't think...

    __________________________________________________________________________________
    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]

    December 19, 2008 at 10:17 am

    #915481

  • RE: Clustered and Non-clustered Index

    Clustered indexes are best on columns used in the GROUP BY/ORDER BY part of queries, and/or if the column in question is used to retrieve a range of values.

    Non-clustered indexes...

    __________________________________________________________________________________
    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]

    December 18, 2008 at 12:20 pm

    #914816

Viewing 15 posts - 796 through 810 (of 1,518 total)