Re: SQL express performens lagg
- From: "aaron.kempf@xxxxxxxxx" <aaron.kempf@xxxxxxxxx>
- Date: 26 Oct 2006 10:54:58 -0700
do you have 'auto update statistics' on?
is your database GROWING?
are you sure it's SQL Server that's slowing down the machine??
how fast is your harddrive? 4200? 5400? 7200? 10k?
how many transactions are you sending to this thing?
are you sure you dont have spyware?
I think that there is some 'autofill with zeroes' settings that you can
do in SQL Express that would make it so that it doesn't need to grow at
all.. without this special tweak it could easiyl consume 100% of
processor for 3 minutes out of every 30 if you were adding a bunch of
records to it.
how many connections do you have open at the same time?
I would definitely check out MSDE and see if it works better; I
appreciate MSDE in a lot of ways-- because it has the SQL agent; and I
think that it has better replication support than SQL Express; I think
that SQL Express can only be a consumer; but I think that MSDE can be a
publisher in some ways; I wish i knew more about this..
but i figure if you're using SQL for temporary storage; you're syncing
up the lowest level details to an upstream server??
(you are storing the details right? or are you aggregating? a
mini-data-warehouse for each desktop lol)
also; how complex is your schema.. how many tables; ballpark
Jacob Ipsen wrote:
Hey I am currently working on at project.
where I have some "problems" regarding to the way the SQL Express is Working
in general.
My setup and goal is the following
Setup
VIA 700Mhz processor 512Mb Ram
OS XPe with SQL express and my shell
my goal is to get the SQL Express to run as fast as possible, without any
for security and fail safe. as the data that the SQL express holds is only
seen in as temporally Storage.
Some may ask why I haven't chosen another type of db(native or other SQL
server)
well first we need an extreme fast data response.
and we tried to other servers that have smaller footprint and lower load
times...
but they couldn't keep up with the SQL Express...
however now we come to my problem.
when my machine have run for some time and run a lot requests
(some TSQL and the heavy ones SP)
it suddenly slows the system down and is using max CPU performance for 10-30
Sec
and then runs 5 - 10 min and does it again.......
can any one help me reach my goals
help will be appriciated
Ps.
I am not trying to compare this with other SQL servers, the performens is
overall ok, but there is some things thath bother me.
the sotton lagg, cant see whay og what it is doing. i could understand this,
if the base where large and tok up a lot of ram.
dut the max i have seen this base grow to is 60Mb for the db and 0,5 for the
log.
again if anyone have a clue to strip down the sqlexpress or other
surgestions... or even use another version (SQL,msde)
then i am all open for surgestions :)
.
- References:
- SQL express performens lagg
- From: Jacob Ipsen
- SQL express performens lagg
- Prev by Date: Row insert timestamp..
- Next by Date: SQL server
- Previous by thread: Re: SQL express performens lagg
- Next by thread: Disable Windows Authentication mode in WDA
- Index(es):
Relevant Pages
|
