Forum Replies Created

Viewing 15 posts - 466 through 480 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (8/11/2013)


    dwain.c (8/10/2013)


    Jeff Moden (8/10/2013)


    Brandie Tarvin (8/2/2013)


    How many people (besides Jeff and myself) have written SQL Spackle articles?

    How many SQL Spackle articles are there?

    Yes, I have a reason...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Greg Edwards-268690 (8/10/2013)


    Stefan Krzywicki (8/10/2013)


    Greg Edwards-268690 (8/9/2013)


    If the services are on, they are running and available.

    We would have people think the time to run a big query was the middle...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Greg Edwards-268690 (8/9/2013)


    If the services are on, they are running and available.

    We would have people think the time to run a big query was the middle of the night.

    So do...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Greg Edwards-268690 (8/9/2013)


    Stefan Krzywicki (8/9/2013)


    Greg Edwards-268690 (8/9/2013)


    I think part of it being suspect of paging lends itself to being run after that largest job of the day.

    At least that is...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Greg Edwards-268690 (8/9/2013)


    I think part of it being suspect of paging lends itself to being run after that largest job of the day.

    At least that is what I get out...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (8/9/2013)


    Ed Wagner (8/9/2013)

    A car actually lasted for 276,000 miles??? That's impressive. I've heard of some holder Honda models making it to the low 200's, but nothing that high

    For all...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (8/9/2013)


    ChrisM@Work (8/9/2013)


    dwain.c (8/9/2013)


    ChrisM@Work (8/9/2013)


    Port Moresby - ranked 139th of 140 cities for liveability, whatever that means. I wonder which city came last? What's the grub like?

    Food's OK....

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Erland Sommarskog (8/9/2013)


    Since there is a theory that SQL Server is being paged out, you should make sure that the service account for SQL Server has the Windows permission "Lock...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/9/2013)


    Stefan Krzywicki (8/9/2013)


    For me the investment is getting something that I won't have to spend much on during its lifetime. I drove my Pathfinder 276,000 miles and kept...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    arnipetursson (8/9/2013)


    Have you had the server guys check the power saving settings on the VM and the host.

    See Brent Ozar's article on this issue:

    http://www.brentozar.com/archive/2010/10/sql-server-on-powersaving-cpus-not-so-fast/

    Also, I am curious why you are...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/9/2013)


    Steve Jones - SSC Editor (8/9/2013)


    Jack Corbett (8/9/2013)


    Just read recently that the Cayenne holds its value better than any other vehicle in its class,...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Brandie Tarvin (8/9/2013)


    Given your other questions, it occurs to me that I clarify this before you start digging into your research.

    Performance Monitor = PerfMon (it's just a shorter way of...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Brandie Tarvin (8/9/2013)


    At this point, you need to run two things during this job running. A profiler trace and Performance Monitor.

    Performance Monitor is a Windows tool that has several SQL...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Strange Job Slowdown 30 secs to 30 minutes

    Greg Edwards-268690 (8/9/2013)


    Stefan Krzywicki (8/8/2013)


    Brandie Tarvin (8/8/2013)


    Yeah, I caught that "other job at 4" comment after I posted.

    Try 3:45 instead.

    If the page file examination doesn't reveal anything, we will.

    I talked...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Fal (8/9/2013)


    Hey Brandie,

    I found a quote you might be able to relate to:

    Ring Lardner

    "A good many young writers make the mistake of enclosing a stamped, self-addressed envelope, big enough for...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

Viewing 15 posts - 466 through 480 (of 2,838 total)