February 2, 2010 at 3:46 am
I've just taken over the job as the DBA at my company. Going through the error logs, i found the error:
"Error 17052: SQL Server has been optimized for 8 concurrent queries..."
I then ran "select @@version", and found out that it's running the personal edition. This explains why users are complaining that the system that is running on this db is at times very slow. It runs 30 databases, with about 100 users, at least 40-50 simultanious users.
I know that I have to upgrade to either Standard or Enterprise edition, but I was looking for a guide, or tips on things that I might forget during this procedure.
In basics, the steps are:
Detach all databases
Script out logins
Uninstall the Personal mssql server
Install Standard/enterprise
Attach the databases
Script in the logins
Am I forgetting something?
February 2, 2010 at 4:17 pm
Don't forget about SQL Agent jobs, maintenance plans, DTS packages, reports (if used), extra stored procedures/functions created...
Joie Andrew
"Since 1982"
February 3, 2010 at 12:07 am
Thanks!
February 3, 2010 at 12:44 am
Have you seen this yet?
How to move databases between computers that are running SQL Server
Joie Andrew
"Since 1982"
February 3, 2010 at 12:50 am
Since you are evaluating an upgrade, I would throw out there the need to evaluate going to SQL 2005 or 2008.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 3, 2010 at 12:54 am
That is a great point, since SQL 2000 ended support in 2008.
Joie Andrew
"Since 1982"
February 3, 2010 at 12:58 am
Thanks Joie.
With that upgrade there are additional considerations to be made - such as converting DTS to SSIS, evaluating server settings, possible proc updates. Take this opportunity to make the system all the better you can.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply