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 |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2012-01-18 : 14:28:06
|
| [url]http://imageshack.us/photo/my-images/39/clipboard01dm.jpg/[/url]I will like to know what are those small horizontal black arrows inside the yellow circles are? I wanted to google it but i didn't know how to. thanks |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-18 : 14:57:54
|
| They indicate that those operators are running in parallel.--Gail ShawSQL Server MVP |
 |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-01-20 : 15:07:37
|
| I have 2 servers: prod and localhost (my local). Both running same sql server version and sp1 ...when run the same query on both servers and I look at the execution plan (control + L) the production one shows an extra icon called Parallelism. Anyone knows why? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-20 : 15:28:31
|
| Because the production one is running in parallel (over multiple CPU cores) and the local one is not. Do you have more than one CPU core in your local machine? If so, is SQL allowed to use more than one (and is it SQL Express)?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
black arrows