Forum Replies Created

Viewing 15 posts - 16 through 30 (of 44 total)

  • RE: SAN Response Times

    Andrew G (1/19/2015)


    High buffer I/O just means high logical IO which is probably just missing indexes or poor performing queries due to the amount of data being processed.

    For example, you...

  • RE: SAN Response Times

    Thanks. The high waits are CXPacket from report queries which I want to advise them to offload to a secondary copy but need the evidence that this would be an...

  • RE: SAN Response Times

    I notice on the activity monitor, I regularly see high wait times on Buffer I/O however there is substantial amount of memory for this server....

  • RE: Database Restore Hangs

    ALZDBA (1/9/2015)


    burfos (1/9/2015)


    ALZDBA (1/8/2015)


    FWIW I hope you enabled Instant File Initialization as it also works for restore operations !

    Instant File Initialization and restores[/url]

    I haven't on this particular server as...

  • RE: SAN Response Times

    Jeff Moden (1/11/2015)


    Lowell (1/11/2015)


    don't be ridiculous. you can run it on production. it's doing what your server is already doing; in this case it creates a four gig file and...

  • RE: SAN Response Times

    It is a production 24/7 system. I wont be able to run that tool on there.

  • RE: query

    peterausger (1/9/2015)


    thank you very much, but one small change if search C or any value between ,,its not returning anything.

    for example if i search c i should get a-b-c

    if i...

  • RE: query

    There is probably a more elegant and efficient way of doing it (see what the gurus reply with) but this works (see attachment as it wont let me post the...

  • RE: Database Restore Hangs

    ALZDBA (1/8/2015)


    FWIW I hope you enabled Instant File Initialization as it also works for restore operations !

    Instant File Initialization and restores[/url]

    I haven't on this particular server as the database...

  • RE: Database Restore Hangs

    Thanks all for the replies. Very helpful. I am definitely running set single user and then immediately running the restore command so nothing in between. There should be no...

  • RE: Schema Changes

    Could a database audit specification be another solution?

  • RE: backupset question

    I believe that restores are indeed recorded in to the backupset table.

    A good blog on this is http://shaunjstuart.com/archive/2010/12/msdb-backupset-table-peculiarity/

    Backupset it seems, simply holds the details of a backup whether it...

  • RE: Still cannot figure passing a variable to procedure

    Yes very very good point. Apologies for not pointing that out. Just answering the problem that was asked. There is a previous thread with the actual original question of what...

  • RE: Still cannot figure passing a variable to procedure

    xp_cmdshell is used to run command shell commands like batch files, executables etc which is probably not what you want. You should simply call

    EXEC (@sql)

  • RE: Still cannot figure passing a variable to procedure

    You need to concat your variable in to your string...

    ALTER procedure [dbo].[totalinstallations]

    @installations nvarchar(1000)

    AS

    BEGIN

    declare @sql nvarchar(1000)

    SET @sql = 'SELECT softwaremanufacturer,productname,productversion,

    sum(distinct case when...

Viewing 15 posts - 16 through 30 (of 44 total)