Professional Web Applications Themes

resource low - Transact-SQL - Microsoft SQL / MS SQL Server

While excuting a stored procedure in Query yzer I update a table over 2000 times. I have a commit after each record processed. At about row 2000 I box appears stating "Resource low, some results are dropped" What does this mean and what do I do to fix it? Thanks Otto...

  1. #1

    Default resource low - Transact-SQL

    While excuting a stored procedure in Query yzer I
    update a table over 2000 times. I have a commit after each
    record processed. At about row 2000 I box appears stating
    "Resource low, some results are dropped"

    What does this mean and what do I do to fix it?

    Thanks
    Otto
    Otto Naesset Guest

  2. #2

    Default Re: resource low - Transact-SQL

    Sounds like you returned a lot of rows to Query yzer which had to keep those rows in the
    result windows and it got memory constrained because of this.

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url]


    "Otto Naesset" <ojnitpnet.com> wrote in message news:054e01c3464e$81a937d0$a101280aphx.gbl...
    > While excuting a stored procedure in Query yzer I
    > update a table over 2000 times. I have a commit after each
    > record processed. At about row 2000 I box appears stating
    > "Resource low, some results are dropped"
    >
    > What does this mean and what do I do to fix it?
    >
    > Thanks
    > Otto

    Tibor Karaszi Guest

Similar Threads

  1. #979 [Opn->Bgs]: [PEAR] Openmarket Transact support
    By pajoye@php.net in forum PHP Bugs
    Replies: 0
    Last Post: December 12th, 12:36 PM
  2. Resource Use
    By MDW in forum ASP
    Replies: 2
    Last Post: July 28th, 01:40 AM
  3. Transact-SQL Debugger
    By Neeraj in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 14th, 01:14 AM
  4. Transact-SQL syntax question
    By Rajan Murthy in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 1st, 03:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139