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 |
|
krishnamurthy
Starting Member
1 Post |
 Posted - 2007-06-26 : 02:33:45
|
| Hello,I have a link server established with different server this is will copy the data from that server to my local server on particular tables,based on these tables, i am filtering some data filling few more local tables by running scheduled job. in this filtering i have created the temp/perment table to store intermediate data after completion of the work i have droped the temp/perment table.like this we have to fill 13 local tables this entire thing will be done in the single job run at specific time. everying thing working fine. but the only problem is during the running of the job the CPU Utilisation is reaching to 100%. is this because of the temp tables concept or any other reason? can any help me out from this.Thanks and Regards,Krishna Murthy K |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-26 : 05:15:20
|
| Would expect this sort of thing to be limited by disk access and have very low cpu usage.Sounds like the queries aren't very ifficient so I would look at the query plans.But if it's not causing a problem do you want to worry about it?==========================================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. |
 |
|
|
|
|
|
Performance Issue