MS SQL Tuning

We are running an application that has hit a limit of 5000 records.  Thought it might be because we are using SQL Express.  We purchased full version of 2008 R2, installed, backed up and restored the DB.  Still we can only see 5K records when I know there are over 15K.  Is there some maintenance I can perform on the DB, do see an option to shrink?  The DB has been running for some years now and no tuning or maintenance has been performed.
Guess it could be the application that is the limitation.  Going to check with the vendor.
Meanwhile would like thoughts from anyone!
WebccAsked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
0
 
Éric MoreauSenior .Net ConsultantCommented:
If you could run a SQL Profiler to check what queries are sent to the server, you would find if the software impose that limit (maybe with a SELECT TOP 5000
0
 
WebccAuthor Commented:
How do you run the Profiler?  I'm not well versed with SQL.
0
 
Éric MoreauSenior .Net ConsultantCommented:
you have a link under Tools in SSMS
0
 
arnoldCommented:
What application are you running?
Where are you only seeing 5000 records, check whether the 5000 record limit is not a configuration/setting within the application. I.e. Only display the first 5000 records.

If you have an option to display items by date, see if you can display data from dates not included in the 5000 record display.

It is highly unlikely to be an issue with the sql server.
Do you get errors when adding records?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.