SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to overcome the slowness issue in MS SQL Serve
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

surjo.aagun
Starting Member

Bangladesh
1 Posts

Posted - 11/12/2012 :  05:19:01  Show Profile  Reply with Quote
I am describing a scenario. I have developed a desktop software is for a data entry company using C# 2.0 and MSSQL Server 2008. This software has around 250 users. In the database, around 6,00,000 data are saved in a single day. Around 200 users enter data through this software whereas the rest 50 users checks the data already inserted. So, all the users are facing the slowness problem during their regular operation. In average 1 user requires 3 minutes to enter 40 lines of data. During the development, table partitioning concept was not applied. Now as the slowness issue rises to a burning stage, how could I solve the issue permanently? Any ideas, advice, guidelines are most appreciated.

Thank you,

Surjo.Aagun

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 11/12/2012 :  06:52:12  Show Profile  Reply with Quote
How are you accessing the database? Via ad-hoc queries (in the C# code), or via stored procedures? In either case, run the query from SQL Server Management Studio and look at the execution plan to see what is taking up the time. (Press control-m in SSMS before you run the query).

With the information you have given, it is hard to say what is causing the slowness - it could be that the hardware is not sufficient, or that the database is not maintained properly, or it could be that the queries are inefficient, or any number of things in between. Try to narrow down the causes by running inserts for a single line as I described earlier.

Edited by - sunitabeck on 11/12/2012 06:52:27
Go to Top of Page

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 11/13/2012 :  01:15:14  Show Profile  Reply with Quote
Yeah I agree with Sunita. There's not nearly enough information to go on, nor are you likely to be able to resolve a complex question online.
Bite the bullet and hire a consultant for a couple of days to actually look at your setup.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000