Solved

MS SQL Tuning

Posted on 2014-03-29
5
146 Views
Last Modified: 2014-04-28
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!
0
Comment
Question by:Webcc
[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
  • 3
5 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39963779
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
 

Author Comment

by:Webcc
ID: 39963796
How do you run the Profiler?  I'm not well versed with SQL.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39963806
you have a link under Tools in SSMS
0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 39963807
0
 
LVL 78

Expert Comment

by:arnold
ID: 39963993
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Display SQL maintenance plan SQL Code 3 46
SQL Server Agent Job Error 13 79
Do not display comma when no last name 8 48
SQL Simple Query Taking a Very Long Time 11 35
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

732 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