Update, the problem still exists. Despite putting the tempdb on sata SSD the tempdb read/write performance is terrible. My cheap laptop IDE is...
Update. I purchased a couple of solid state drives and moved my tempdbs to them. This cut execution time in half as the script uses tempdb...
What could be causing this? Other DBs on the same drive exist, but they are inactive. Might it just be because the problem DB is sharing the same...
Turns out hyperthreading is not the problem. The performance gain I saw when turning HT off was due to the test script short circuiting itself. I...
here are a couple of links describing the issue and related: http://blog.stackoverflow.com/2010/10/database-upgrade/...
Thanks. I've timed the operations w/in the proc to the second and across the board all operations take 3-6x times as long on the new system. I agree...
Bueller? Anyone?
The SQL versions match the system OS. It is SQL 2008 64 Bit Enterprise Edition SP1 on the 64 bit Core i7. All the systems mentioned above are...
It's not just limited to this one script. I've got another job that I run regularly that takes 6 hours on the Core i7 and 1.5 hours on the Core2 Duo...
This is crazy, even my laptop can outperform the Core i7. I've got a cheap Dell Vostro 1520 laptop that can run the script in 2.5 hours! It's...
I don't think the poor performance has anything to do with stats as the script creates a DB from scratch. No stats would exist.
What can explain this poor performance?? I have a SQL script that I run regularly. The script takes 8 hours to run on my brand new Dell Corei7, but...
This won't work for numbers greater than 32. you will generate the error below Maximum stored procedure, function, trigger, or view nesting level...
Separate names with a comma.
