Forum Replies Created

Viewing 15 posts - 211 through 225 (of 312 total)

  • RE: unable to connect to the instance

    Perry Whittle (4/29/2014)


    need a biot more info on the server spec and the resources assigned (such as max mem setting) to the other instances.

    We have 6 instances running on VM....

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Server Side Trace

    I will try to dig a little deeper but the problem is that I don't have anybody to talk to yet about what procedure it's calling and when it happens?...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Server Side Trace

    @Shwan:

    Is there a way you can look at the attachment. I just wanted to know if those numbers look normal.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: unable to connect to the instance

    I don't know if its too late for me to ask for some help since this post is 3 days old.

    I bumped up the memory and I also enabled Resource...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: unable to connect to the instance

    I just bumped up the MAX memory and enabled Resource Governor and its working fine now.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: unable to connect to the instance

    Koen Verbeeck (4/24/2014)


    Is resource governor enabled?

    It could also be a bug, do you have all the service packs applied?

    Resource Governor is not enabled.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: unable to connect to the instance

    My bad. I thought it was resolved but no.

    I was able to restart the service but everytime I try to run a simple query. it gives me an error:

    insufficient system...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: unable to connect to the instance

    This issue has been solved

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Question regarding adding instances.

    sqlbuddy123 (4/15/2014)


    If only one DB per customer, you could probably put those 2 instances on the existing server itself. Before that check if that VM is having any resource contention...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Question regarding adding instances.

    sqlbuddy123 (4/14/2014)


    How many DBs are you going to add per new customer ? And why do you want to add 2 instances ?

    We are adding 2 instances for 2 more...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Question regarding adding instances.

    tim_harkin (4/14/2014)


    Create a baseline to see what current server utilization is. You may be able to add dozens more databases to the existing environment, or you may be already...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Copy DB from Prod to QA

    I found what I was looking for.

    http://sqlserverzest.com/2013/10/03/sql-server-encrypting-and-securing-native-backups-using-transparent-data-encryption-tde/

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Copy DB from Prod to QA

    I did run into some problems and I am wondering if someone can tell me what to do.

    I was unable to restore the DB because the DB we have in...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Copy DB from Prod to QA

    ScottPletcher (3/31/2014)


    Yes, restore the qa db from a production backup. Create a script that does that, including all the appropriate "WITH MOVE ... TO ..., MOVE ... TO ..."...

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

  • RE: Copy DB from Prod to QA

    Thanks everybody for replying. Can I use import export utility? Just asking.

    "He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]

Viewing 15 posts - 211 through 225 (of 312 total)