Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jason123456
Starting Member
8 Posts |
 Posted - 2011-12-13 : 04:29:18
|
| If the web side connect msqql server . May i know how many number of record in table affect loading performance?How to solve or trace whether issue on web or sql server ?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-13 : 04:41:08
|
| you can get record count by run trace using sql profiler------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jason123456
Starting Member
8 Posts |
Posted - 2011-12-16 : 03:39:45
|
| is it every transaction record ?is it use a lot of resources? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-16 : 06:43:23
|
quote:
Originally posted by jason123456
is it every transaction record ?is it use a lot of resources?
sorry didnt get what you're asking. please elaborate------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sql table number of record