Hi,
We have an issue currently where our Microsoft SQL server runs close
to 100% CPU for a lot of the time. There also seems to be a lack of
memory cache hits (we would expect a reasonable amount given the
traffic for our site).
Our website generates a lot of small queries (approximately 200odd
q
I would say it is from running it on VMWare. I have never had good
experiences running SQL server on VMWare. There just isn't the grunt there
to do it. I started shifting my SQL servers to VMs and started having CPU
issues so i moved them back to physical servers.
-Original Message-
From:
What Steve says is def. contributing to it.
Another thing I'd look into before moving it away from VMWare though would be
the VMWare setup itself, e.g. assigned memory, giving it more CPU power etc.
How's your disk IO looking on that VM?
Cheers
Kai
On 24/11/2010, at 11:48 AM, Steve Onnis wrot
We're running SQL Server 2005 quad core on VMWare, and it works fine without
any problems.
On 24 November 2010 09:48, Steve Onnis wrote:
> I would say it is from running it on VMWare. I have never had good
> experiences running SQL server on VMWare. There just isn't the grunt there
> to do it.
Hello Barry,
Some people say to obtain maximum performance the JDBC driver should
transmit data
to the database server in packets that are equal in size to the
maximum packet size configured on the database server.
For SQL to check packet size:
-SQL Management Studio (connect to server etc)
-Serv
On 24/11/2010 09:53, Kai Koenig wrote:
What Steve says is def. contributing to it.
Another thing I'd look into before moving it away from VMWare though would be
the VMWare setup itself, e.g. assigned memory, giving it more CPU power etc.
How's your disk IO looking on that VM?
We use SQL2008
I haven't checked in a while but the jtds driver (http://
jtds.sourceforge.net/) used to be faster than default JDBC driver CF
come's with for MSSQL
On Nov 24, 7:13 am, BarryC wrote:
> Hi,
>
> We have an issue currently where our Microsoft SQL server runs close
> to 100% CPU for a lot of the time
Hello Pat,
I use the divers built in CF. The JDBC divers in CF8/9 are type4. I
see datadirect has released jdbc type5 drivers:
http://web.datadirect.com/products/jdbc/index.html
Regards, Carl.
> I haven't checked in a while but the jtds driver (http://
> jtds.sourceforge.net/) used to be faster
Just a quick note to make a few things clear:
- the type doesn't reflect on the quality. E.g. a type 4 driver is not better
than a type3 driver and a type5 driver not necessary better than a type4
driver. They just do things in different ways. I just want to avoid that the
type is seen as a qua
Hi Everyone,
Most will be aware that (at my work) I'm currently altering our monolithic
application into several discreet services and that we're using Robin
Hilliard's (Rocketboots) open source "Galaxy" service, service.
It's all progressing quite nicely - but I have an (almost) silly question
10 matches
Mail list logo