Re: SQL express performens lagg

In article <45387d9e$0$145$157c6196@xxxxxxxxxxxxxxxxxxxxx>, "Jacob Ipsen" <jip@xxxxxxxxxxxxxxxxxxxx> wrote:
Hey

This works like a charm Ed :)

but sadly this still dosent solve my overall problem,
with the lagg.

the server still laggs some times... i allmoste feels like the server is
clering cashe or somthing.. it runs rely slow for aboudt 5-7 min and
after that it runs fine again...

dos any one have a clue to what the server dos doing this "lag" time ??

The Db is configured to run with simple log mode
the server is configured as defaulte, the only modification we have made to
the configuration is
we defined a max memory loft, otherwise the sql express swolloved all the
512 memory that ouer system runs with.

keep in mind that this system is only running SQL express and My Custom
Shell
on a Win XPe

Jacob


How large is the Pagefile?
Check how much paging is going on.
Also, if it's slowing down for a few minutes, then returning to normal, what's
eating CPU during that slow time?

Task Manager can tell you both of these things.

.

Relevant Pages

  • Re: SQL express performens lagg
    ... the server still laggs some times... ... the configuration is ... 512 memory that ouer system runs with. ... keep in mind that this system is only running SQL express and My Custom ...
    (microsoft.public.sqlserver)
  • Re: SQL express performens lagg
    ... the server still laggs some times... ... the configuration is ... 512 memory that ouer system runs with. ... keep in mind that this system is only running SQL express and My Custom ...
    (microsoft.public.sqlserver)
  • Re: SQL express performens lagg
    ... dude you're a dipshit for using that CPU ... the server still laggs some times... ... the configuration is ... 512 memory that ouer system runs with. ...
    (microsoft.public.sqlserver)
  • Re: SQL express performens lagg
    ... the server still laggs some times... ... the configuration is ... 512 memory that ouer system runs with. ... keep in mind that this system is only running SQL express and My Custom ...
    (microsoft.public.sqlserver)
  • Re: SBS SP 1 installation error
    ... Component Name: Microsoft Exchange Forest Preparation ... Component Name: Server Configuration ... Component Name: Windows Server 2003 Configuration ... Component Name: Networking Configuration ...
    (microsoft.public.windows.server.sbs)