Forum Replies Created

Viewing 15 posts - 196 through 210 (of 312 total)

  • RE: How to add parameter in the report

    I was able to create a parameter but there are some issues I am running into and wondering if I can get some help from the community? I also included...

    "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: How to add parameter in the report

    Sure, I will try to give you as much information as I can.

    I have this report which I created but my manager wants to be able to sort it out...

    "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: Help with creating a SQL script.

    Ed Wagner (5/29/2014)


    Good. Create a stored procedure and schedule it to run as a database job every hour. The procedure would query the number of rows meeting your...

    "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: Help with creating a SQL script.

    We should be ok if it runs every 60 to 90 minutes.

    "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 'd like to run this trace between 8 am and 2 pm and I just wanted to know if it looked OK, I got this from the website but...

    "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: SQl server is running slow

    Grant Fritchey (5/9/2014)


    The query against sys.dm_exec_requests will show all the queries running as well as any blocking. You can see the resources being used, how long a query has been...

    "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: SQl server is running slow

    Sorry forgot to mention. This is another query I ran before I restarted the service, but couldn't find any blockage.

    SELECT client_net_address as HOSTIP,Blocking.session_id as BlockingSessionId , Sess.login_name AS BlockingUser ,...

    "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: SQl server is running slow

    Yes I did rebuild all the indexes but I don't think that was the issue since the performance problem started today and restarting the service solved it.

    32 GB of memory....

    "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: SQl server is running slow

    cunningham (5/9/2014)


    So this is only at certain times on certain days? At those times have you ran activity monitor to get a view on the status of the system? anything...

    "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: Creating a trigger if the DB is down?

    Thanks.

    "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

    Beautifully explained. Thanks guys. Cleared almost everything. :satisfied:

    "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

    Grant Fritchey (4/29/2014)


    Yeah, but that's index fragmentation. Shrinking and growing a database file fragments at the OS level. There's a decent little article about how to look at this over...

    "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 ran this to find out how fragmented all the indexes were and it gave me only 2 indexes which were more than 80% fragmented. So I don't think fragmentation...

    "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

    GilaMonster (4/29/2014)


    I'd run a server-side trace and do the analysis that was described in the article you mentioned in your initial post. I wrote that article for a reason.... 😀

    Or,...

    "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

    GilaMonster (4/29/2014)


    Why on earth would you do that?

    We are putting a STOP to that. No more shrinking

    GilaMonster (4/29/2014)


    There's nothing in what you show to go on. In fact, I can't...

    "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 - 196 through 210 (of 312 total)