Cpu 100 %

[lovezone]

CPU 100%.

Help

http://image.free.in.th/z/iw/87cats.jpg

log

0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE ODBC GET RESULT] 1765ms [{ call dbo.ProcUpdateItemPCL (11719, 312960, 7731, 0, 0, 0, 0, 0, 7731, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE METHOD] 1765ms(QueryTime 1765ms) [{ call dbo.ProcUpdateItemPCL (11719, 312960, 7731, 0, 0, 0, 0, 0, 7731, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE QUERY] 1750ms [{ call dbo.ProcUpdateItemPCL (29351, 881107, 9677, 0, 0, 0, 0, 0, 9677, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE ODBC GET RESULT] 1750ms [{ call dbo.ProcUpdateItemPCL (29351, 881107, 9677, 0, 0, 0, 0, 0, 9677, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE METHOD] 1750ms(QueryTime 1750ms) [{ call dbo.ProcUpdateItemPCL (29351, 881107, 9677, 0, 0, 0, 0, 0, 9677, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE QUERY] 1969ms [{ call dbo.ProcUpdateItemPCL (33510, 1025740, 75, 0, 0, 0, 0, 0, 75, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE ODBC GET RESULT] 1969ms [{ call dbo.ProcUpdateItemPCL (33510, 1025740, 75, 0, 0, 0, 0, 0, 75, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:38	[DB PROFILE METHOD] 1969ms(QueryTime 1969ms) [{ call dbo.ProcUpdateItemPCL (33510, 1025740, 75, 0, 0, 0, 0, 0, 75, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:39	[DB PROFILE QUERY] 1954ms [{ call dbo.ProcUpdateItemPCL (24742, 739163, 8778, 0, 0, 0, 0, 0, 8778, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:39	[DB PROFILE ODBC GET RESULT] 1954ms [{ call dbo.ProcUpdateItemPCL (24742, 739163, 8778, 0, 0, 0, 0, 0, 8778, 0) }]
0x00645150 1 ei.console.tmp->ei.console.txt D:\PANGYA_SRV Repack.v2\Py_GameServer\Log/20201_20110217_1742.1.ei.console.tmp ]]  0x00EF48A0 1 1 ] 2011-02-17 17:50:39	[DB PROFILE METHOD] 1954ms(QueryTime 1954ms) [{ call dbo.ProcUpdateItemPCL (24742, 739163, 8778, 0, 0, 0, 0, 0, 8778, 0) }]

[MentaL]

[chreadie]

You have high response times on the quieries, whats your setup?

Disk-speed
CPU
Memory-speed
Processlist

Do you have any kind of tracing or logging on for sql server?
Posted via Mobile Device

[lovezone]

Intel Solidstate Harddisk 80GB SSD SATA M SERIES 2.5
Intel(R) Core(TM)i5 CPU
Ram 12.0 GB
Windows Server 2008 R Enterprise

[PHOENIXXXX]

Are you using Windows Seven ? 32 or 64 bits ?

[lovezone]

64 bits

[PHOENIXXXX]

i would rather check the SSD, certainly not properly set up.

[chreadie]

How long does it go 100%? in the screenshot its like 1 second which isnt much.

And check eventual tracing.

[PHOENIXXXX]

maybe i got the answer: next time you get this problem checkout if the pangya sql server is still running in the sql server configuration.

[chreadie]

If it isnt running he wouldnt get responses.