Forum Replies Created

Viewing 15 posts - 331 through 345 (of 1,518 total)

  • RE: memory consumption on sql server 2008 64 bit server.

    I would suggest that you set a value for the max-mem setting value to say 2 or 3 GB.

    Keep in mind that max-memory refers to the buffer-pool area of memory;...

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

    March 18, 2011 at 5:33 pm

    #1300859

  • RE: Uneven usage of CPUs in SQL 2005 environment: some CPUs consistently busier than others

    Thanks again!

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

    March 18, 2011 at 1:56 pm

    #1300789

  • RE: Uneven usage of CPUs in SQL 2005 environment: some CPUs consistently busier than others

    Pam Brisjar (3/18/2011)

    I hear you. Had to fight some of those battles myself. But make sure you're doing your due diligence and at least presenting the information 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]

    March 18, 2011 at 1:43 pm

    #1300779

  • RE: Uneven usage of CPUs in SQL 2005 environment: some CPUs consistently busier than others

    Pam Brisjar (3/18/2011)

    It could also be how you have your virtual server set up. Make sure you're following best practices as recommended by Microsoft and your VM vendor for...

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

    March 18, 2011 at 12:43 pm

    #1300741

  • RE: Uneven usage of CPUs in SQL 2005 environment: some CPUs consistently busier than others

    Jason Selburg (3/18/2011)

    My guess would be that it's normal. The process by which the multiprocessor uses it's available cores is quite complex (I won't even pretend to know)

    But I would...

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

    March 18, 2011 at 12:40 pm

    #1300738

  • RE: Uneven usage of CPUs in SQL 2005 environment: some CPUs consistently busier than others

    Any thoughts 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]

    March 18, 2011 at 9:53 am

    #1300617

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    fannonland2 (3/3/2011)

    ok, changed that line back to

    iWaitInMinutes = 1

    iAlertFreq = 1

    sAnalysisInstance = "server\instance"

    sAnalysisDB = "dbName"

    and the other line is now....

    sConnString = "Server=" & sAnalysisInstance & ";Database=" & sAnalysisDB &...

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

    March 3, 2011 at 3:31 pm

    #1294378

  • RE: Migration Strategy for my environment

    Steve Jones - SSC Editor (3/3/2011)

    If you have new hardware, you will install the new software on it, then move logins

    Login migration: http://www.sqlservercentral.com/articles/934/

    Move over databases from either a backup/restore or...

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

    March 3, 2011 at 12:07 pm

    #1294223

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    fannonland2 (3/2/2011)

    I appreciate you taking the time to talk me through this. I am not a DBA by any stretch but I am trying to convince the DBA's that...

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

    March 2, 2011 at 2:37 pm

    #1293751

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    fannonland2 (3/2/2011)

    ok, so it sounds like I need to go into SQL management Studio, create a new database called "Analysis" and then run the blocking tables.sql against that new...

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

    March 2, 2011 at 11:29 am

    #1293653

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    fannonland2 (3/2/2011)

    Hmm, then I guess I am misreading your instructions. It says I need to run scripts scom blocking.sql. I do that on the scom server? 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]

    March 2, 2011 at 11:16 am

    #1293646

  • RE: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts

    fannonland2 (2/28/2011)

    Just trying to understand what you are doing here with your scripts. I am trying to stop my IT department from buying Quest Tools or Foglight and hoping...

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

    February 28, 2011 at 2:21 pm

    #1292592

  • RE: Access that can allow to execute SP (create object), however not allow to create/drop/alter table from query window

    There are two ways you can achieve this (they can be combined into one):

    EXECUTE AS clause:

    http://msdn.microsoft.com/en-us/library/ms178106.aspx

    Module signing:

    http://msdn.microsoft.com/en-us/library/ms178106.aspx

    Have a look at the above links and post further on this thread with...

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

    February 25, 2011 at 8:29 pm

    #1291877

  • RE: Need script to get historical data on Windows users connected to Report Server and most-viewed reports

    I found these two links, which seem very relevant to my question:

    http://www.mssqltips.com/tip.asp?tip=1114

    http://www.mssqltips.com/tip.asp?tip=1306

    If anyone has any additional info, it would be appreciated.

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

    February 25, 2011 at 12:55 pm

    #1291733

  • RE: Is it possible to get the actual login that last modified a stored procedure?

    Thank you all for your responses.

    This is a QA environment, so there are indeed a lot of changes happening all the time.

    I will study all your answers in more...

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

    February 24, 2011 at 6:29 am

    #1290921

Viewing 15 posts - 331 through 345 (of 1,518 total)