SQL express performens lagg

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 :)



.

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Web App Security Model.
    ... SQL permissions are correctly restrictive (so worse case the allowed ... If these machines are standalone the threats posed by them are ... applications / implementation and whether their design has ... My company wants to have a few Windows Servers running web app's (ASPX ...
    (microsoft.public.security)
  • Re: Union Query with a Crosstab Query
    ... FROM clause of your SQL statement. ... I just see all blanks in the 'Goals' Field...but it certainly ... queries are combined in another query which is a Union Query. ... Now, I split out the sales rep revenue, by rep and by advertiser, ...
    (microsoft.public.access.queries)
Loading