Forum Replies Created

Viewing 15 posts - 106 through 120 (of 134 total)

  • RE: Query Cache questions

    Thank you for our reply it worked.

  • RE: Page File Optimization 2012 sp4

    Hi,
    Virtual page file memory
    What kind of OS - Windows ( Server2012 standard), 64gb Ram.
    Do you mean the size of the pagefile.sys, or the possibility, to split the...

  • RE: Login sa failed


    Data from default trace..
    The login is failed by username "Domain\dbc_agent" in all the places, Db is 'master'.
    The maintenance plan is running and has 3 jobs for backup...

  • RE: Login sa failed

    Thanks, yes your right, logs does not help. 
    So running default trace do I have to change any value in above script?
    I tried to run this in Test environment...

  • RE: Login sa failed

    Lowell - Thursday, November 8, 2018 3:09 PM

    using ping -a will return the machine name, i like it better than nslookup..
    then you can...

  • RE: Login sa failed

    We have 3 nodes B01 and B02. the IP which is in the error is for B02. 
    I might be wrong but I ran the nslookup cmd on B02 and...

  • RE: Login sa failed

    nslookup shows it is coming from Domain controller...and not one but team is aware they get multiple errors not sure what is the cause...is there any way to find the...

  • RE: Please advise - Patching questions

    Thanks Michael..yes it is 2012 version. Appreciate your sharing information.. surely helps. Thank you!

  • RE: Please advise - Patching questions

    I absolutley agree with your advice about the test server. I will push for it and see it that is a possibility or create awareness of the advantage of having...

  • RE: Please advise - Patching questions

    Great Jason! thanks for sharing your thoughts and guidance. 
    one of the things I will be doing now is plan on 2-3 hrs of downtime notice..
    If anything goes wrong...

  • RE: Please advise - Patching questions

    Thanks you for all the answers!

    I might be wrong with 30 mins for downtime, and not sure what is the good amount of time for downtime? How do...

  • RE: Secondary DB in restoring state

    Thank you! for your advice.

  • RE: SSRS report using SP's

    Please find the code below for 1 of one the SP's for you to understand  and 'attached' sample data from all the SP's( please see the different workbooks/tabs in .xls)...

  • RE: SSRS report using SP's

    Thanks, yes,  I am trying to get the data from all the 10 SP's but the problem is when I try to create the dataset it only allows 1 sp...

  • RE: Maintenance agent jobs

    Thank you....actually the recurring option for jobs was not checked. That is strange and must have been unchecked by someone doing maintenance or migration.

Viewing 15 posts - 106 through 120 (of 134 total)