Solved

sql 2008 express locking up

Posted on 2011-02-11
4
328 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 15

Expert Comment

by:MohammedU
ID: 34876027
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
ID: 34876095
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
ID: 34883465
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
ID: 34896408
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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
View SQL database for NPS accounting 4 23
connection to SQL 2012 error in windows 10 18 49
Group Policy 5 20
SQL Query 20 23
OfficeMate Freezes on login or does not load after login credentials are input.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

751 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