Forum Replies Created

Viewing 15 posts - 166 through 180 (of 360 total)

  • RE: 3 node clustering in sql server 2008 R2

    yeah.. I just deleted them and added back to the DNS...now when i do an nslookup from each server to a different one I see both the IP addresses for...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: 3 node clustering in sql server 2008 R2

    I am using the same names. The only difference is I added a new nic card to each server.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: 3 node clustering in sql server 2008 R2

    For my testing I have destroyed my entire cluster that I built and I am rebuilding the 3 node clustering with two network cards and when I am trying to...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Profiler: should the audit login and audit logout always match in a profiler

    But if they dont match does it mean the connections are still open by the end of my trace? The question came up because the dev team wanted to identify...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Perfmon Issue

    I think I figured out the issue..I had the perfmon running while the service account was being changed...I will restart the sql server service and check if that fixes the...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Perfmon Issue

    That query returns me zero records...I wonder the zeros got anything to do with the permissions of new SQLServer Service account that has been put in place of local system..please...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Perfmon Issue

    SQLRNNR I have just run the command as an administrator but I still see the zeroes for all the above perfmon counters. But I dont see any issues as of...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Perfmon Issue

    Thanks for the reply SQLRNNR..but would this require any service or server reboot? or would it affect any apps connected to the sql server right now if i execute the...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Perfmon Issue

    I am using SQL Server 2008 R2 X64 SE on Windows Server 2008 R2 EE.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Determine the correct size for a data file autogrow

    one last thing is on my test environment I have the sqlserver services running under local system account (unlike our production env where I changed it to run under a...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Determine the correct size for a data file autogrow

    Thanks for the info guys. Yes, I knew about the instant file initialization and I have already scheduled to implement it.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Determine the correct size for a data file autogrow

    I never use percentage for autogrow. I only use whole numbers. Most of the times I use something between 200MB and 500MB, depending on what I think will be enough....

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: 3 node clustering in sql server 2008 R2

    One last thing is.. is it mandatory to have 2 nic cards for each individual node when implementing sql clustering in sql server 2008 R2 EE X64bit on windows server...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: 3 node clustering in sql server 2008 R2

    I figured out the issue...Node C was newly built and the firewall was enabled...I disabled the firewall and am able to connect now from my laptop to sql instances after...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: 3 node clustering in sql server 2008 R2

    Ok, as I read that you have a default instance and a named instance. And that looks fine to me. I have two as well but am only showing one.

    I'd...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 15 posts - 166 through 180 (of 360 total)