Rookie question, there is literally tons of literature regarding Perfmon, and tons of queries.

Do you have an example of a query you want me to run?

I also only have...

Data File - 500MB

Log File - 1 GB

Those are TempDB files...one of my other DB's is 60 GB.

"And I don't recall, did you have CPU spikes or DISK IO spikes...

Eight(8) TempDB files - Each file is 2 GB.

I have the same desktops in two locations, and the results are the same on both desktops.

The server tests are being done via a RDT session onto the server as...

Desktop script.

Desktop using names instead of * .... 18 seconds

Server using names instead of * ... 26 seconds

Server using Select * with fully qualified table name.... 25 seconds

Roy Ernest (2/17/2010)

---

Just couple of stupid questions. I already know the answer but just for the sake of it..

1. Do you see any Wait for resources while running on the...

Server SSMS query to file - 35 seconds

Desktop SSMS query to file - 25 seconds

Eight processors

CirquedeSQLeil (2/17/2010)

---

isuckatsql (2/17/2010)

---

SQLBOT (2/17/2010)

---

DegreeOfParallelism="0" means unlimited parallelism (up to number of procs)

I do also note that parallelism = "false" in the xml of both. Not 100% sure if it...

SQLBOT (2/17/2010)

---

DegreeOfParallelism="0" means unlimited parallelism (up to number of procs)

I do also note that parallelism = "false" in the xml of both. Not 100% sure if it means what...

Please find attached the Actual Execution Plan from my home desktop.

Thanks

CirquedeSQLeil (2/16/2010)

---

I would give that a shot.

Also, out of curiosity. I know the disk subsystem is better on the server. Is it a san or locally attached disks?...

I did a reorg and reindex on the server, but the query still took 25 secs.

Please find attached the Actual Execution Plan from the server query.

I cant provide the...

CirquedeSQLeil (2/16/2010)

---

Anything else running on the server besides SQL?

Nope, just SQL Server 2008.

Are the statistics up to date on the server?

I dont know how to check this? I have...