July 1, 2009 at 9:56 am
We have a program developed in Vs 2005. This week, the program performs very slowly when it request to SQL Sever 2005. In Query Analyser, the same SQL requests have good performances. When I clean the buffer with theses 3 commands,
checkpoint
go
dbcc freeproccache
go
dbcc dropcleanbuffers
go
The performances are very good in my program for approximately 2 hours. Have you any idea what can cause my problem?
Thank.
July 1, 2009 at 10:03 am
Tell us about your SQL server, architecture, amount of memory, other processes on that machine, etc.
CEWII
July 1, 2009 at 10:08 am
Could you provide us with the actual queries please.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 1, 2009 at 11:31 am
SQL 2005 32 bit sp2
OS: Windows server 2003 64 bit
Processor: 1 Quad-core Xeon
Memory: 12 gigs
Raid 10
July 1, 2009 at 12:31 pm
You will need to post the query that is causing problems and the table structures, the specs of your machine dont mean anything by themselves
July 7, 2009 at 6:14 pm
I agree, but I think he was answering my question first..
Given that config 32-bit SQL 2005, not sure of the version of SQL but unless he has done the additional config he isn't using hardly any of that memory..
CEWII
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply