May 26, 2010 at 9:12 am
The query that I am running is
SELECT pKey,ownerkey,lastmodified,hp,volts,speed_rpm,IsSixtyHz,amps,HasVfd,LastEditDate,OffLevel,CreationDate,LastChangeKey,xmldata,alarmtemplate FROM AcMachine where (LastEditDate > 0) OR CreationDate > 0
most of the time this query will time out when running on Windows 7, but every so often the statement will run perfectly. I have tested on more than 1 Windows 7 machine and they all exhibit the same problem on the same query. The server is XP x64 Sql Server Standard. I am at a loss where to start even looking for the problem. The only thing mildly interesting is that the 'xmldata' column is a binary data column (not an xml column).
Any thoughts or input would be appreciated.
May 26, 2010 at 11:09 am
Have you looked at the execution plans between different operating systems? It's hard to compare performance between different os's especially if you then toss in that Win 7 is a client machine, not a server, differences in memory, cpu, disk...
All you can really do is look to the machine and try to determine why the query is running slow. In terms of the query itself, it's pretty simple, but, is it using available indexes on the table? Are other things running on the server that could cause contention?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply