• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1317
  • Last Modified:

What does this mean? Maximum number of unique SQL exceeded

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
0
williamfl
Asked:
williamfl
1 Solution
 
reb73Commented:
Are you running a profile trace or performance logging in the background? Can you isolate/identify the action that is causing this error??
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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.
0
 
williamflAuthor Commented:
It was an issue with the HP diagnostics .net probe. Just had to adjust the max URI capabilities. Info install document.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now