January 12, 2009 at 6:15 am
Hi All,
I have fine tuned a query from 4 hours to 5 minutes. I have execute the same query( fine tuned one) in other server. It took 20 seconds only.
say for example,
Server Details:
DEV_SERVER1
DEV_SERVER2
Assume, i have execute my query on DEV_SERVER1. It took 5 minutes.
Now, i have executed the same query(Not even modified a single dot) on DEV_SERVER2. It took 45 seconds only.
So i just thought the following things may get affect the query performance.
1) RAM capability
2) HARD DISK space
3) No of users connected to that server
4) No of applications installed in that server
Please let me know whether my thoughts are correct or not.
it would be appreciable if somebody add more points.
🙂
karthik
January 12, 2009 at 8:45 am
Data volumes
Memory
Disk speeds and usage
CPU speed
database activity
other server activity
Different indexes or statistics
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 12, 2009 at 8:47 am
Different execution plan
January 12, 2009 at 8:53 am
Different data in the tables
Data cached on one and not on the other
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 13, 2009 at 1:00 am
Gila,
what do you mean by database activity ?
karthik
January 13, 2009 at 1:04 am
karthikeyan (1/13/2009)
what do you mean by database activity ?
Activity within the database. Users running queries.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 13, 2009 at 1:09 am
Thanks Gila,
I forgot to ask....
what do you mean by Hard disk speed and CPU speed ? is there any difference between them ?
karthik
January 13, 2009 at 1:19 am
Hard Disk speed - read/write speed on the hard disk (depends on RPM, number of heads, spindles)
CPU speed - your processor's speed (measured in Ghz)
HDD speed matters as you'd do IO on the physical disk to bring in/out data for processing.
CPU speed matters as this will determine how quickly it processes the request of ur query.
January 14, 2009 at 2:27 pm
If you are using a copy of the same database on both servers, maybe 'stale' staistics.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
January 16, 2009 at 12:25 am
Now i got access to both the server.
how should i check the disk speed ?
how should i look CPU speed ? ( from Task manager window ? )
karthik
January 16, 2009 at 12:27 am
I think i should turn on
set statistics io on
&
set statistics time on
right ?
karthik
January 16, 2009 at 9:58 am
hi
Look for STATISTICS IO in BOL and you will see it's returning information about the activity generated by your SQL query.
Number of pages read from memory, or disk, etc...
If I understand your question correctly you want information about your hardware.
If you go to Properties on My Computer, you can see what processor you have running in the General Tab. (pentium 4 cpu xx Ghz). You can also see how much RAM is installed from there.
If you do the same on your disk (right click, properties) you should be able to find out the model you have and from there we can find the details online on the vendor's website.
Is this what you are looking for?
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply