| Author |
Topic |
|
dolishah
Starting Member
5 Posts |
 Posted - 2006-05-22 : 23:38:18
|
| I m new with sql server. My sql server is responding too slow when large no of records are there. What should I do?Thanks in advanceShradhha Shah |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-22 : 23:39:57
|
What is your query doing ? Is the tables indexed ?
KH |
 |
|
|
dolishah
Starting Member
5 Posts |
Posted - 2006-05-22 : 23:48:57
|
quote:
Originally posted by khtan
What is your query doing ? Is the tables indexed ?
KH
Yes it is index talbled and query simpaly updates one tables from 3/4 tables. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-05-22 : 23:58:54
|
can you post your query ?
KH |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-23 : 00:00:37
|
| you have not given us any information that we can use to help you out.-ec |
|
|
|
dolishah
Starting Member
5 Posts |
Posted - 2006-05-23 : 00:10:46
|
quote:
Originally posted by khtan
can you post your query ?
KH
My problems is little different. I am using large data base having morethan 3 Million records. One single table has more than 2 million records. So times any simple query like select * from propdetail which give results in 30 sec in sql server 2000 will take morethan 2 min in sql 2005. I am using asp.net so result is time out expired in application. Can i miss something ? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-23 : 17:50:31
|
| Have you reindexed and updated statistics on the 2005 server? Is the server and instance for 2005 the same as the one 2000 is on? What are the specs for both? What type of disk subsystem are both these servers on? What do the performance monitor counters for physical read and write queue lengths look like when you run the query on the two systems? Have you looked at Profiler or the execution plan to determine if you have issues?You really aren't selecting 2 million records back into your asp.net application are you? If so, rewrite the application because that's stupid.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-23 : 18:39:12
|
| >> You really aren't selecting 2 million records back into your asp.net application are you? If so, rewrite the application because that's stupid.Maybe the users want to scroll through 2 million rows. I've had users that didn't realise what that meant.Does that query always take 2 mins? Maybe it's something else going on on the server that's holding it up.Try it in query analyser (thingamy management thingamy - doesn't have the same ring) on the server to see what happens - return results in text rahter than a grid so you can see when they start.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-23 : 18:44:20
|
| I'm betting that the ethernet is running 10mbit half duplex instead of 100 or 1000 Full..-ec |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-23 : 18:45:01
|
quote:
Originally posted by derrickleggett...If so, rewrite the application because that's stupid...
You just gave the correct answer to 95% of the questions posted on SQLTeam.CODO ERGO SUM |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-23 : 18:49:46
|
quote:
Maybe the users want to scroll through 2 million rows. I've had users that didn't realise what that meant.
If so, rewrite the application because that's stupid.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-23 : 18:51:13
|
quote:
Originally posted by eyechart
I'm betting that the ethernet is running 10mbit half duplex instead of 100 or 1000 Full..-ec
Or it could be a network card thowing a lot of errors when it fails to auto-negotiate the correct speed.Or maybe the new server is located on the other side of a WAN link.CODO ERGO SUM |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-25 : 11:34:55
|
| any update on this issue?-ec |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-26 : 03:53:02
|
quote:
Originally posted by dolishah
I m new with sql server. My sql server is responding too slow when large no of records are there. What should I do?
Remove the large number of records.-------Moo. :) |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-05-26 : 10:00:53
|
| Excellent advice. Truncate the table, and then your query will run lickety-split. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
SQL 2005 is too slow