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
Hi Chris- I'm not sure if this response will be helpful but I too have had some major issues with "sql connection issues... runtime issues... locking during queries... crashing out during queries... not exporting data properly... and on and on." I know in my case it is not a server issue as we have a brand new server dedicated to RE with lots of room. In my specific situation, this was mostly happening to me as I am the only one that moves or groups large amounts of data (imports, exports, queries, complex reports, etc...). The problem here was a combination of RE hogging system resources when it is processing data and "a known issue with the ethernet drivers that were loaded on my computer. After some review, I noticed that the older computers, though slower tended to maintain their connections even during processes that took several hours. Our IT department updated my drivers and the problems have been greatly alleviated. HTH, Jana