UK Karting - Notice Board (Chat) : Re: Any idea why that should be John? NT

Notice Board (Chat)

Re: Any idea why that should be John? NT
Posted by 'itpro' on 09 Jun 2009 @ 13:11

| View Message Thread | Reply to this message |

itproJoined: August 2001
Total Posts: 6
[ View User Profile ]

I have no inside knowledge on this but I can see an easy cause for this which can occur in databases which MIGHT be the problem.

The machine processing the requests (the server) can have a limited amount of Ram. Once it's needs to use more Ram than it has available, it can create a 'swap file' where it moves parts of the 'memory requirement' to the hard disk. Writing and reading hard disks is MUCH slower than reading/writing ram.

Once the database grows enough to EXCEED the available ram, you get HUGE slowing as the system as it spends too much time 'swapping' the data from Ram to Disk.

This slowing has happened before and the cure seems to coincide with Dick and Martin 'archiving' the older threads.

I'll email Dick and Martin.

Ian

Message Thread:

SQL Server error by 'DanTheK1RaceGearMan' (07 Jun 2009 @ 21:17)

Re: SQL Server error by 'razh54' (07 Jun 2009 @ 22:06)

Re: SQL Server error by 'Shanny' (07 Jun 2009 @ 22:43)

Re: SQL Server error by 'JJJ' (08 Jun 2009 @ 16:10)

Re: SQL Server error by 'John' (08 Jun 2009 @ 17:09)

Any idea why that should be John? NT by 'JJJ' (08 Jun 2009 @ 19:09)

Re: Any idea why that should be John? NT by 'Roblin' (08 Jun 2009 @ 21:56)

Re: Any idea why that should be John? NT by 'DanTheK1RaceGearMan' (08 Jun 2009 @ 22:48)

Re: Any idea why that should be John? NT by 'itpro' << You are here!

I've emailed Dick and Martin by 'itpro' (09 Jun 2009 @ 16:10)

Re: I've emailed Dick and Martin by 'richpudd2003' (09 Jun 2009 @ 16:56)

Post a Reply:

You may post a direct reply to this message which will appear in this thread.
To post a new or unrelated message use This Form. Top of Page
Notice Board Index

[ UK Karting Main Index ]


News	Karts & Karting	Notice Board	Market Place	Companies Directory	Tracks Directory	Events Calendar	Race Results	Photo Gallery	Links