What does this mean? Maximum number of unique SQL exceeded

Posted on 2009-02-19
Last Modified: 2012-05-06
We are currently testing a SharePoint system wit dot net 2.0 page and we are seeing the following message
From a server request  call Sqlcommand.Executereader(),    Maximum number of unique SQL exceeded.
Has anyone seen this type of arguments results?
Maximum number of unique SQL exceeded
Question by:williamfl
    LVL 25

    Expert Comment

    Are you running a profile trace or performance logging in the background? Can you isolate/identify the action that is causing this error??
    LVL 57

    Expert Comment

    by:Raja Jegan R
    I believe its because of overuse of server resource.

    Use Perfmon to watch the resource usage status, and for the line in read, we only can know its the peak value in during the process of your application.

    What I suggest is opening your SQL profile and starting a new trace to track the SQLServers behavior, and make a compare with your performance tool and try to catch the SQLServers behavior while the peak point occurs in your performance tool. In this way, it maybe can help you find the potential cause of the problem.

    Accepted Solution

    It was an issue with the HP diagnostics .net probe. Just had to adjust the max URI capabilities. Info install document.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now