Forum Replies Created

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

  • RE: SQL Server 2008 R2 EE Active-Passive Cluster Installation Issue

    you seems to have missed cluster validation report, if you do not have rights it will certainly tell that in report....check that report again

    here's the location: systemroot\Cluster\Reports

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: SQL, VMs, and Backups... Oh my...

    I am with same delimma, here are the options we are considering....

    Continue taking sql backups as usual but take them directly to central backup location (CIFS)

    Alternatively veem backup solution...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: Existing standalone SQL 2008 R2 server to failover cluster question...

    Perry Whittle (1/12/2012)


    garthwaimr27 (1/12/2012)


    1. Just run the cluster setup on the existing server? Can I keep my existing server\instance name if I do this?

    No, it doesn't work like...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: High avalibility - what is best ?

    Considering above discussion have you looked into below scenerio....

    Implement 2 node w2k8R2 (Site1Node1 & Site1Node2) cluster in first data center vsql called Site1Node

    Implement 2 node w2k8R2 (Site2Node1 & Site2Node2) cluster...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: SQL Server 2008 R2 SP1 64x cluster active/active

    Jamie,

    as Gail mentioned clustering for HA only....pear 2 pear has its own complexity and for such a volume might not be the best bet...

    Your best bet would to wait for...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: SQL Server 2008 SP2 Update

    Akkare (8/12/2011)


    Thanks for your update.I did the same way.

    Now I have one doubt.

    We have Cumulative Updates and Hotfixes for every SP.How we can Identify these required or not and how...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: SQL Server 2008 SP2 Update

    I do assume service needs to be restarted, even if its not required I prefer to reboot the server (host) and then install service pack and CU as needed than...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: Performace problem with sql server 2008 r2 and framework 3.5

    Seems like blocking issue, Try this...

    Quick SQL Server Sessions Troubleshooting

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: bcp out - dump file to another domain

    <<TCP Provider: No such host is known. >> try debugging why this message is coming....

    from source machine try below...

    ping to see ip is accesible

    telnet to below ports to ensure file...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: Clustered index seek on View

    Agustin,

    Ideally you should be able to avoid 18 table clustered index seek to 1 table only as all 18 tables have same no of columns. This is assuming you have...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: intermittent connection timeout

    Its node one of cluster, if you are asking its a named instance then yes it is named instance....

    Yes, this is source and log backup job is failing

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: Loading Data With Powershell

    cmille19 (1/8/2009)


    There are some extra returns in the code in the article. Try this instead (notice the line breaks are different):

    param ( [string]$ComputerName = "." )

    Get-WmiObject -computername "$ComputerName" Win32_LogicalDisk -filter...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: Interesting deadlock with no fix

    that link been used by me before posting this thread, i was wondering if i am missing something here...it seems a bug in deadlock graph...hoping to get a second opinion

    open...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: sql server very slow

    carloparcon (2/5/2010)


    to prakash: i did the query tonite but the proc is wasnt there , maybe because i instructed the desk clerk to logout then login again.

    but still i suspect...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • RE: sql server very slow

    carloparcon (2/4/2010)


    to prakash, i cant kill these process coz its being use by our Front desk cashier, you know were in a hotel industry

    no application usually allows any process to...

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

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