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 |
|
ysweet
Starting Member
4 Posts |
 Posted - 2004-04-25 : 10:51:37
|
| Does anyone know why isql.exe executes an SQL file containing many GO separators so long. I feel that there is a dalay between each SQL batch executed. No HDD activity, no CPU usage. It is very annoying when running large SQL sript creating SP and views, etc. Thank you |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-25 : 11:02:11
|
| What does profiler tell you ?Damian |
 |
|
|
ysweet
Starting Member
4 Posts |
Posted - 2004-04-25 : 11:06:15
|
| Nothing :)If you run a file likeGOGOGOGOGO(200 times enough to see delay)there are no SQL statements, only separators. I get this sample after trying to find a reason why SQL server consumes SP definitions so long. So, what I see that this is a proble of ISQL.exe. Handmade utility to run SQL script creates the same SPs 20 times faster. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-25 : 14:45:00
|
| But did you run a profiler to see where it showed the time being consumed???MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
ysweet
Starting Member
4 Posts |
Posted - 2004-04-26 : 06:33:34
|
| just try to do what I have described, and you will see what I ask. There are no SQL statements in the given sample, and therefore no activity except connection to SQL server. |
|
|
|
|
|
|
GO and ISQL and OSQL utils