Hi,
We have a database of aroung 500 MB. The Number of concurrent users are more than a thousand. Database is not fully optimized and we are working on it. One of the requirements is to obtain the knowledge of the server load at a particular point of time abd limiting the output of a query to certain number of rows.
Also is there any way to anticipate the time and number of rows likely to be returned by a query before the execution completes?
Just thinking aloud, will creating an user defined performance counter come to any help This might generate an alert once the memory usage/disk I/O flows beyond a threshold mark. But how shall we SQL Server recognize the event? Can the SET ROWCOUNT will come to any help to limit the size of the output recordset (assuming the sql server identifies a heavy load on the server)?
Any idea about the second issue?
Will really appreciate your suggestions.
Thanks