Solved

sql 2008 express locking up

Posted on 2011-02-11
4
319 Views
Last Modified: 2012-06-27
Hi all,

quick background on my issues , basically we supply document management systems which run on sql , a company gave us a brand new windows server 2008 just for our app which we installed sql 2008 express on and for about 2 months everything was working lovely, then another
server went down in their office that contained some sort of legacy system database , so they put it onto our server and turned off something called oportunistic locking to allow this other system have several connections in at a time , the performance of our sql went down and when the server was rebooted suddenly our sql was locking up regularly , anyway they took the legacy system back off our server and supposedly turned oportunistic locking back on , i was still getting the same issues so i completely removed sql and
then re-installed it but i am still getting the same problem so if anyone has any ideas on how to check whats causing the problem please let me know .

thanks
0
Comment
Question by:eitrax
4 Comments
 
LVL 15

Expert Comment

by:MohammedU
Comment Utility
What version of SQL express you install.
Check the database sizes...
If you have installed SQL 2008, I believe db size limit is 4 GB
If you have installed SQL 2008 R2 then db size is 10 GB.

Did you check the SQL error log and Event log, see if there are any errors and/or warnings in there?
0
 
LVL 22

Accepted Solution

by:
8080_Diver earned 500 total points
Comment Utility
What sort of legacy system database did htey instal?  (For instance, was it an old SQL Server, such as 2000, 7.0 or, heaven forbid, 6.5 ;-)?

What else did they install?

Do you have a full back up of the server before they installed the legacy system?  If so, you may need to back up your database, recover the full backup, and then restore your database.
0
 
LVL 35

Expert Comment

by:David Todd
Comment Utility
Hi,

The assumption that the a) the uninstall was done correctly and b) that the uninstall itself was clean aren't necessarily valid.

For instance, if you install an old version of SQL over a newer version - even if separate named instances, there maybe stuff that the older instance overwrites that an uninstall wont fix and you'll need to reinstall the newer version.

I'd like to see this machine rebuilt as in reinstall the operating system then resintall your rdms and stuff. And charge the client for the privaledge. You mightn't be able to do this though for a bunch of reasons.

Key thought - you've just proved that the install/uninstall wasn't "clean" no matter what anyone else says, so rebuild the machine.

Regards
  David
0
 

Author Comment

by:eitrax
Comment Utility
hi guys thanks for the replys , i don't have any info on the legacy systems but i do have backups which i did a restore from and now everything seems to be working fine especially after adding indexes on my tables
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now