Independent School Educators network

I was wondering what DB you were using for Blackbaud? Are you on the free SQL MSDE 2000, 2003? Have you upgraded to the standard edition? Did it improve BB speed at all? Has anyone made the jump to 2005 SQL yet? What is the size of your DB?


We are about to convert the last piece of Financial Edge to version 7, therefor we will now be able to upgrade our MSDE 2000 to 2005. I also found out that if your DB is over 1GB then upgrading to the full version of SQL will improve performance. Something I am going to try this summer.

Views: 20

Replies to This Discussion

Hey Justin,
We're on FE/EE 7 and when we ran an update last fall it forced an update to the "free" SQL 2005 Express. Noone could get to their data until we figured out we had to grant them permission to "view server state" [one of the settings accessed through SQL management studio express.] A nice feature of this version is the Windows authentication. [Knocking loudly on wood] there haven't been any speed complaints. I don't know if it got faster with this update, because I wasn't here previously, but it seems to be running well. Andrew is planning to rebuild the server this summer because the original installation had some settings which were done in a way that weren't optimal. He'd have more details on that. Our FE/EE DB is about 2 Gbs. RE is under 1. hth. -d
Good to know. When we went to version 7 all of my users complained about how slow things became, even though my server and desktop specs were WAY above what BB suggested. I am wondering if investing in SQL 2005 Standard would help. BB cant give me a yes or no on this. I only have 4 users that connect to this DB so upgrade to standard would only cost me $300.
We're using the full MSSQL 2005 Standard Edition, which can scale up to 4 nodes for High Availability before having to get the Enterprise Edition.

Currently, we're just getting started with EE and I haven't looked at FE in a while but our DBs are very much under 1GB. We don't have any performance problems that are a result of the DB engine (some with our network, that I'm currently working on).
Move from SQL 2000 to SQL 2005 this year. Not sure of size at this point, probably around 1.7 gb. Moved because SQL 2000 is end of life.

RSS

Latest Activity

Profile IconJennifer Pavlacky and claudia holzbauer joined Independent School Educators network
yesterday
Colleen Schilly is now a member of Independent School Educators network
Tuesday
Elizabeth Allen joined Dan Teitelbaum's group
Thumbnail

World Languages Teachers

Let's discuss current issues in world language teaching and learning (previously known as "Foreign…See More
Monday
Chris Shriver joined Dirk DeLo's group
Thumbnail

STEM

STEM for Girls Think Tank
Monday
Chris Shriver joined Charlie Mitchell's group
Thumbnail

21st Century Skills

What do we need to do in order to better equip our students to become true leaders in a "flat…See More
Monday
Joel Josephson posted a discussion
May 18
Jill Brown replied to Tami Brass's discussion What hardware are you choosing? in the group Windows 8 1to1 Programs
"We are just now looking at machines and are comparing the Lenovo and Fijitsu. Any current updates…"
May 16
Alex White is now a member of Independent School Educators network
May 16

Welcome

to this network for and by educators using blogging, discussions, PLNslist-servsprofiles, bookmarks, twitter, wikis, videos, and other tools to discuss teaching and learning.

Please read our Community Guidelines and know that most content posted on this site is publicly accessible.

More info:

   • Sign-up process
   • OK I joined. now what?

If you need help, please contact us.

© 2013   Created by Demetri Orlando.

Badges  |  Report an Issue  |  Terms of Service