I have also posted this under raisers admin section but then thought this may be a better place....

Ok, I dont really know where to begin here. I guess i just need a little reassurance from other admins of raisers. We have about 6 faily active users with a db of about 1.5 gb in size. Its running on a 2003 server using the sql 2005 included with raisers. There is only 2gb of ram in the server.

It seems users are always having multitudes of issues with raisers. Could be sql connection issues... runtime issues... locking during queries... crashing out during queries... not exporting data properly... and on and on. The problem is that most of  the issues work when raisers reopens or there is a solution in the knowledge base that fixes the issue. That really might not seem like a problem to some but it really is as when one issue is resolved a new one always replaces it or the issue comes back a day or two later...

My users are beyond frustrated... I have over the last year done multitudes of suggestions from blackbaud to find and fix errors to no avail. Even so far as to building a new server that the only thing it does is serve raiser's. Which in retrospect was probably the right idea from the beginning but i was not the admin here then and have inherited these issues. Now even in the new server I began with having the same issues. Finally i have it set to run all the maintenance options every night and the users mostly make it through the day without errors. The problem now seems to be on days when bigger queries are being run the errors keep coming back before days end.

I am sure there is other info i should be putting here... I am just pulling my hair out, getting a major headache from end user complaints. I just wanna know if there are others out there that have similar issues or headaches with raisers having daily issues or are the people out there that raisers runs fluidly for all the time. And if so would you share your specs and what you do to keep it this way?

Thanking you all in advance... Greatly. I mean you have no idea how grateful i am. :-) 

-Chris Lambert

clambert@mcht.org