High Memory utilisation and slow apps
Posted on 2006-05-03
I am not sure if this is a server problem or a SQL problem but hopefully someone can help. We have a server with around 3 SQL databases running on it. The users of the applications that are accessing these databases are complaining that it is slow. I have checked the server and it seems that the memory utilisation was at 73% constant. A defrag and a reboot of the server was performed last night and I have checked the server this morning. Memory utilisation is now 60% constant but it seems to be rising by about 1% every 5 hours. I have spoken to the users this morning and they are complaining that the applications are still slow although not as bad. I have checked the event viewer and it has many of the following errors:-
ODBC error encountered, State = 23000, native error = 515, error message = [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails..
The data portion of event 19000 from MSSQLSERVER is invalid.
Can anyone help?