Forum Replies Created

Viewing 15 posts - 4,951 through 4,965 (of 9,244 total)

  • RE: HA on Active / ACtive and DR on DB Mirroring

    Kishore-132325 (9/25/2012)

    I have 2 SQL Servers in HA set up in Active / Active cluster where we have one DB - named XYZ. Versions : Windows Server 2008 R2 and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 25, 2012 at 3:40 am

    #1541729

  • RE: Question about sys.dm_os_process_memory

    No, it's not. This value

    locked_page_allocations_kb

    is a part of

    physical_memory_in_use_kb

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 25, 2012 at 1:33 am

    #1541678

  • RE: Active /Active configuration

    saidapurs (9/24/2012)

    Hi All,

    I configured SQL cluster configuration successfully as Active /Passive but i am not understand how do i configure...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 25, 2012 at 1:07 am

    #1541670

  • RE: Move DB from 2008R2 Enterprise to 2008 Standard

    mcopa (9/24/2012)

    Can I use the Copy Database wizard?

    if you use the detach\attach method no you can't.

    If you use the object method trnasfer it might work as it reads the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 12:11 pm

    #1541560

  • RE: Local group permissions issues

    Jason Marshall (9/24/2012)

    We restore Production backups to our UAT server nightly to keep data refreshed. The devs are given access through a local server group. When the restores...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 8:52 am

    #1541455

  • RE: SQL Server Consolidation Advice

    if it were me i would separate SSRS and SSIS to one box and put SSAS on its own

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 8:49 am

    #1541450

  • RE: Degree of parallelism in SQL Server

    braju (9/24/2012)

    From what I have seen as reponses, I think we should set the MAXDOP to default to 0 and adjust cost threshold of parallelism if needed or even ahve...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 7:55 am

    #1541408

  • RE: Changing Locations of DataFile

    saidapurs (9/24/2012)

    Hi Gila/Perry,

    Thanks for your response even i observed required less down time for this...

    Thanks & Regards

    Satish

    No problem, the main thing is...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 6:59 am

    #1541383

  • RE: Degree of parallelism in SQL Server

    look closely at the cost threshold parameter and also check for rogue queries and tune them 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 6:55 am

    #1541381

  • RE: SQL Server Consolidation Advice

    You could certainly consolidate the database engine instances to one box, whether or not you have a box that's capable of providing the level of performance you'll require from the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 6:42 am

    #1541377

  • RE: Changing Locations of DataFile

    runal_jagtap (9/24/2012)

    then Move the files manually from C Drive to the new location & then start the DB..

    I always copy the files then remove the originals when the database starts...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 6:31 am

    #1541373

  • RE: Changing Locations of DataFile

    saidapurs (9/24/2012)

    could you tell me what is the difference on Detach/attach process and above process.....??

    Thanks & Regards

    Satish Saidapur

    Detach removes the database from the system. Offli9ning the database keeps it attached...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 6:28 am

    #1541370

  • RE: Changing Locations of DataFile

    saidapurs (9/24/2012)

    Hi Gail,

    I observed the files are not moved particular path, currently Data & log files are in 'C' drive itself.....

    When i executed below query get...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 24, 2012 at 5:56 am

    #1541356

  • RE: Third Party Backup Technologies

    Andrew Pruski (9/18/2012)

    RedGate - SQL DBA Bundle

    Quest - LiteSpeed

    Idera - SQL Safe Backup v 7.2

    If anyone is currently using any of the products, could you let me know what your...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 23, 2012 at 1:35 pm

    #1541227

  • RE: Degree of parallelism in SQL Server

    braju (9/21/2012)

    I have a question on Degree of Parallelism. I basically want to know the best practice or guidelines to set the degree of parallelism. I looked at the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

    September 23, 2012 at 1:25 pm

    #1541226

Viewing 15 posts - 4,951 through 4,965 (of 9,244 total)