I'm having a performance Issue with my Production SQL Server (2 x Xeon
Dual-Core Woodcrest 1.6Ghz, 2GB RAM, IIS, SQL Server). In general the
querys take much longer than the querys in my development server . For
example a recursive UDF takes 20s in my development server and 2m in
my production server (both with same users load) but my production
server it's much hardware powerfull than the other server.
I start monitoring an realized that the Prod. Server consumes a lot of
Physical Disk Reads and Writes when i execute this example UDF query,
then I realized that the Prod. Server has a SATA RAID1 Disk Mirroring
and my Dev. Server do not has mirroring.
It seems that the RAID1 disk performance seems to be very important
when I execute this query, and my question is WHY??
If the query only reads one Table 'CentroCostos' witch has 1255
records, why DISK performance is so important? It should work with
this info on memory and not have to use so much disk i/o.
Please help me understand this to solve this problem.
Thanks, AR
SET QUOTED_IDENTIFI ER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCo sto (@ccs_ids VARCHAR(4000))
RETURNS @Ret TABLE (ccs_id INT)
AS
BEGIN
DECLARE @ccs_ccs_id INT, @cantidad INT, @ccs_id INT
IF @ccs_ids = 'null'
RETURN
SELECT @cantidad = COUNT(*) FROM dbo.fn_split(@c cs_ids,',')
IF @cantidad = 1
BEGIN
SELECT @cantidad = COUNT(*) FROM CentroCosto WHERE ccs_ccs_id
= @ccs_ids
IF @cantidad = 0
BEGIN
INSERT INTO @Ret SELECT @ccs_ids
RETURN
END
ELSE
BEGIN
INSERT INTO @Ret SELECT @ccs_ids
DECLARE ListadoCcs CURSOR FOR ( SELECT ccs_id FROM
CentroCosto WHERE ccs_ccs_id = @ccs_ids )
OPEN ListadoCcs
FETCH NEXT FROM ListadoCcs INTO @ccs_id
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO
@Ret
SELECT
a.ccs_id
FROM
dbo.fn_CentroCo sto(@ccs_id) As a
FETCH NEXT FROM ListadoCcs INTO @ccs_id
END
CLOSE ListadoCcs
DEALLOCATE ListadoCcs
END
END
ELSE
BEGIN
DECLARE ListadoCcs CURSOR FOR ( SELECT a.Value FROM
dbo.fn_split(@c cs_ids,',') AS a )
OPEN ListadoCcs
FETCH NEXT FROM ListadoCcs INTO @ccs_id
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO
@Ret
SELECT
ccs_id
FROM
dbo.fn_CentroCo sto(@ccs_id)
WHERE
ccs_id not in (select ccs_id from
@Ret)
FETCH NEXT FROM ListadoCcs INTO @ccs_id
END
CLOSE ListadoCcs
DEALLOCATE ListadoCcs
END
RETURN
END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFI ER OFF
go
IF OBJECT_ID('dbo. fn_CentroCosto' ) IS NOT NULL
PRINT '<<< CREATED FUNCTION dbo.fn_CentroCo sto >>>'
ELSE
PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCo sto >>>'
go
7  1779 
Firstly , could you confirm the 2 dbs are similar in terms of
indices,statist ics and execution plans. For example, when your run the UDF
are they similar exceution plans?
--
Jack Vamvas
_______________ _______________ _____
Search IT jobs from multiple sources- http://www.ITjobfeed.com
"Andres Rormoser" <ar*******@gmai l.comwrote in message
news:6d******** *************** ***********@i7g 2000prf.googleg roups.com...
I'm having a performance Issue with my Production SQL Server (2 x Xeon
Dual-Core Woodcrest 1.6Ghz, 2GB RAM, IIS, SQL Server). In general the
querys take much longer than the querys in my development server . For
example a recursive UDF takes 20s in my development server and 2m in
my production server (both with same users load) but my production
server it's much hardware powerfull than the other server.
I start monitoring an realized that the Prod. Server consumes a lot of
Physical Disk Reads and Writes when i execute this example UDF query,
then I realized that the Prod. Server has a SATA RAID1 Disk Mirroring
and my Dev. Server do not has mirroring.
It seems that the RAID1 disk performance seems to be very important
when I execute this query, and my question is WHY??
If the query only reads one Table 'CentroCostos' witch has 1255
records, why DISK performance is so important? It should work with
this info on memory and not have to use so much disk i/o.
Please help me understand this to solve this problem.
Thanks, AR
SET QUOTED_IDENTIFI ER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCo sto (@ccs_ids VARCHAR(4000))
RETURNS @Ret TABLE (ccs_id INT)
AS
BEGIN
DECLARE @ccs_ccs_id INT, @cantidad INT, @ccs_id INT
IF @ccs_ids = 'null'
RETURN
SELECT @cantidad = COUNT(*) FROM dbo.fn_split(@c cs_ids,',')
IF @cantidad = 1
BEGIN
SELECT @cantidad = COUNT(*) FROM CentroCosto WHERE ccs_ccs_id
= @ccs_ids
IF @cantidad = 0
BEGIN
INSERT INTO @Ret SELECT @ccs_ids
RETURN
END
ELSE
BEGIN
INSERT INTO @Ret SELECT @ccs_ids
DECLARE ListadoCcs CURSOR FOR ( SELECT ccs_id FROM
CentroCosto WHERE ccs_ccs_id = @ccs_ids )
OPEN ListadoCcs
FETCH NEXT FROM ListadoCcs INTO @ccs_id
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO
@Ret
SELECT
a.ccs_id
FROM
dbo.fn_CentroCo sto(@ccs_id) As a
FETCH NEXT FROM ListadoCcs INTO @ccs_id
END
CLOSE ListadoCcs
DEALLOCATE ListadoCcs
END
END
ELSE
BEGIN
DECLARE ListadoCcs CURSOR FOR ( SELECT a.Value FROM
dbo.fn_split(@c cs_ids,',') AS a )
OPEN ListadoCcs
FETCH NEXT FROM ListadoCcs INTO @ccs_id
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO
@Ret
SELECT
ccs_id
FROM
dbo.fn_CentroCo sto(@ccs_id)
WHERE
ccs_id not in (select ccs_id from
@Ret)
FETCH NEXT FROM ListadoCcs INTO @ccs_id
END
CLOSE ListadoCcs
DEALLOCATE ListadoCcs
END
RETURN
END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFI ER OFF
go
IF OBJECT_ID('dbo. fn_CentroCosto' ) IS NOT NULL
PRINT '<<< CREATED FUNCTION dbo.fn_CentroCo sto >>>'
ELSE
PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCo sto >>>'
go
Yes, the database are exactly the same (it's a restore from the
previous day) .
Exactly the same Execution Plans. I already update statics in the
database, also measure Memory/CPU/Virtual Memory/Disk I/O.
But can determine where the problem is. Now i'm installing a RAID 1 in
my development machine, to test if that is the problem, but i don't
think so.
On 15 feb, 16:54, "Jack Vamvas" <DEL_TO_RE...@d el.comwrote:
Firstly , could you confirm the 2 dbs are similar in terms of
indices,statist ics and execution plans. For example, when your run the UDF
are they similar exceution plans?
--
Jack Vamvas
_______________ _______________ _____
Search *IT jobs from multiple sources- *http://www.ITjobfeed.com
"Andres Rormoser" <arormo...@gmai l.comwrote in message
news:6d******** *************** ***********@i7g 2000prf.googleg roups.com...
I'm having a performance Issue with my Production SQL Server (2 x Xeon
Dual-Core Woodcrest 1.6Ghz, 2GB RAM, IIS, SQL Server). In general the
querys take much longer than the querys in my development server . For
example a recursive UDF takes 20s in my development server and 2m in
my production server (both with same users load) but my production
server it's much hardware powerfull than the other server.
I start monitoring an realized that the Prod. Server consumes a lot of
Physical Disk Reads and Writes when i execute this example UDF query,
then I realized that the Prod. Server has a SATA RAID1 Disk Mirroring
and my Dev. Server do not has mirroring.
It seems that the RAID1 disk performance seems to be very important
when I execute this query, and my question is WHY??
If the query only reads one Table 'CentroCostos' witch has 1255
records, why DISK performance is so important? It should work with
this info on memory and not have to use so much disk i/o.
Please help me understand this to solve this problem.
Thanks, AR
SET QUOTED_IDENTIFI ER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCo sto (@ccs_ids VARCHAR(4000))
RETURNS @Ret TABLE (ccs_id INT)
AS
BEGIN
* *DECLARE @ccs_ccs_id INT, @cantidad INT, @ccs_id INT
* *IF @ccs_ids = 'null'
* * * *RETURN
* *SELECT @cantidad = COUNT(*) FROM dbo.fn_split(@c cs_ids,',')
* *IF @cantidad = 1
* *BEGIN
* * * *SELECT @cantidad = COUNT(*) FROM CentroCosto WHERE ccs_ccs_id
= @ccs_ids
* * * *IF @cantidad = 0
* * * *BEGIN
* * * * * *INSERT INTO @Ret SELECT @ccs_ids
* * * * * *RETURN
* * * *END
* * * *ELSE
* * * *BEGIN
* * * * * *INSERT INTO @Ret SELECT @ccs_ids
* * * * * *DECLARE ListadoCcs CURSOR FOR ( SELECT ccs_id FROM
CentroCosto WHERE ccs_ccs_id = @ccs_ids )
* * * * * *OPEN ListadoCcs
* * * * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * * * *WHILE @@FETCH_STATUS = 0
* * * * * *BEGIN
* * * * * * * *INSERT INTO
* * * * * * * * * *@Ret
* * * * * * * *SELECT
* * * * * * * * * *a.ccs_id
* * * * * * * *FROM
* * * * * * * * * *dbo.fn_CentroC osto(@ccs_id) As a
* * * * * * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * * * *END
* * * * * *CLOSE ListadoCcs
* * * * * *DEALLOCATE ListadoCcs
* * * *END
* *END
* *ELSE
* *BEGIN
* * * *DECLARE ListadoCcs CURSOR FOR ( SELECT a.Value FROM
dbo.fn_split(@c cs_ids,',') AS a )
* * * *OPEN ListadoCcs
* * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * *WHILE @@FETCH_STATUS = 0
* * * *BEGIN
* * * * * *INSERT INTO
* * * * * * * *@Ret
* * * * * *SELECT
* * * * * * * *ccs_id
* * * * * *FROM
* * * * * * * *dbo.fn_CentroC osto(@ccs_id)
* * * * * *WHERE
* * * * * * * *ccs_id not in (select ccs_id from
@Ret)
* * * * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * *END
* * * *CLOSE ListadoCcs
* * * *DEALLOCATE ListadoCcs
* *END
* *RETURN
END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFI ER OFF
go
IF OBJECT_ID('dbo. fn_CentroCosto' ) IS NOT NULL
* *PRINT '<<< CREATED FUNCTION dbo.fn_CentroCo sto >>>'
ELSE
* *PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCo sto >>>'
go- Ocultar texto de la cita -
- Mostrar texto de la cita -
Also we test other heavy queries and they work OK in both machines, it
seems that the problem is when the query use this specific UDF.
On 15 feb, 17:43, Andres Rormoser <arormo...@gmai l.comwrote:
Yes, the database are exactly the same (it's a restore from the
previous day) .
Exactly the same Execution Plans. I already update statics in the
database, also measure Memory/CPU/Virtual Memory/Disk I/O.
But can determine where the problem is. Now i'm installing a RAID 1 in
my development machine, to test if that is the problem, but i don't
think so.
On 15 feb, 16:54, "Jack Vamvas" <DEL_TO_RE...@d el.comwrote:
Firstly , could you confirm the 2 dbs are similar in terms of
indices,statist ics and execution plans. For example, when your run the UDF
are they similar exceution plans?
--
Jack Vamvas
_______________ _______________ _____
Search *IT jobs from multiple sources- *http://www.ITjobfeed.com
"Andres Rormoser" <arormo...@gmai l.comwrote in message
news:6d******** *************** ***********@i7g 2000prf.googleg roups.com...
I'm having a performance Issue with my Production SQL Server (2 x Xeon
Dual-Core Woodcrest 1.6Ghz, 2GB RAM, IIS, SQL Server). In general the
querys take much longer than the querys in my development server . For
example a recursive UDF takes 20s in my development server and 2m in
my production server (both with same users load) but my production
server it's much hardware powerfull than the other server.
I start monitoring an realized that the Prod. Server consumes a lot of
Physical Disk Reads and Writes when i execute this example UDF query,
then I realized that the Prod. Server has a SATA RAID1 Disk Mirroring
and my Dev. Server do not has mirroring.
It seems that the RAID1 disk performance seems to be very important
when I execute this query, and my question is WHY??
If the query only reads one Table 'CentroCostos' witch has 1255
records, why DISK performance is so important? It should work with
this info on memory and not have to use so much disk i/o.
Please help me understand this to solve this problem.
Thanks, AR
SET QUOTED_IDENTIFI ER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCo sto (@ccs_ids VARCHAR(4000))
RETURNS @Ret TABLE (ccs_id INT)
AS
BEGIN
* *DECLARE @ccs_ccs_id INT, @cantidad INT, @ccs_id INT
* *IF @ccs_ids = 'null'
* * * *RETURN
* *SELECT @cantidad = COUNT(*) FROM dbo.fn_split(@c cs_ids,',')
* *IF @cantidad = 1
* *BEGIN
* * * *SELECT @cantidad = COUNT(*) FROM CentroCosto WHERE ccs_ccs_id
= @ccs_ids
* * * *IF @cantidad = 0
* * * *BEGIN
* * * * * *INSERT INTO @Ret SELECT @ccs_ids
* * * * * *RETURN
* * * *END
* * * *ELSE
* * * *BEGIN
* * * * * *INSERT INTO @Ret SELECT @ccs_ids
* * * * * *DECLARE ListadoCcs CURSOR FOR ( SELECT ccs_id FROM
CentroCosto WHERE ccs_ccs_id = @ccs_ids )
* * * * * *OPEN ListadoCcs
* * * * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * * * *WHILE @@FETCH_STATUS = 0
* * * * * *BEGIN
* * * * * * * *INSERT INTO
* * * * * * * * * *@Ret
* * * * * * * *SELECT
* * * * * * * * * *a.ccs_id
* * * * * * * *FROM
* * * * * * * * * *dbo.fn_CentroC osto(@ccs_id) As a
* * * * * * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * * * *END
* * * * * *CLOSE ListadoCcs
* * * * * *DEALLOCATE ListadoCcs
* * * *END
* *END
* *ELSE
* *BEGIN
* * * *DECLARE ListadoCcs CURSOR FOR ( SELECT a.Value FROM
dbo.fn_split(@c cs_ids,',') AS a )
* * * *OPEN ListadoCcs
* * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * *WHILE @@FETCH_STATUS = 0
* * * *BEGIN
* * * * * *INSERT INTO
* * * * * * * *@Ret
* * * * * *SELECT
* * * * * * * *ccs_id
* * * * * *FROM
* * * * * * * *dbo.fn_CentroC osto(@ccs_id)
* * * * * *WHERE
* * * * * * * *ccs_id not in (select ccs_id from
@Ret)
* * * * * *FETCH NEXT FROM ListadoCcs INTO @ccs_id
* * * *END
* * * *CLOSE ListadoCcs
* * * *DEALLOCATE ListadoCcs
* *END
* *RETURN
END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFI ER OFF
go
IF OBJECT_ID('dbo. fn_CentroCosto' ) IS NOT NULL
* *PRINT '<<< CREATED FUNCTION dbo.fn_CentroCo sto >>>'
ELSE
* *PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCo sto >>>'
go- Ocultar texto de la cita -
- Mostrar texto de la cita -- Ocultar texto de la cita -
- Mostrar texto de la cita -
Andres Rormoser (ar*******@gmai l.com) writes:
I'm using SQL Server 2000 8.00.2039.
I finnaly solve the problem!! The clasic restart! I restarted the SQL
Server and now it's working in 15s like it should.
No, that operation should run in far less than 15s if you coded
it properly. It's more difficult than on SQL 2005, but I'm still
prepare to take the challenge if I get the tables and data to play
with.
Now, my question is why? It's a good practice to restart SQL server
every x days? Memory related issues? Is there any DBCC command to
"clean" memory?
No, it's definitely not a good idea to restart SQL Server on regular
basis. That is just a waste of time.
It sounds that you simply were the victim of a poor execution plan.
When SQL Server first biulds the execition for a function or a stored
procedure, it sniffs the input parameters and uses these values as
guidance. If the first call is with atypical parameters, this can lead
to a less good plan for the common case. In such case you could have
achieved the same result with sp_recompile on your function to flush
the plan for from the cache.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
No, it's definitely not a good idea to restart SQL Server on regular
basis. That is just a waste of time.
It sounds that you simply were the victim of a poor execution plan.
This is the same conclusion I came to in the parallel thread in
microsoft.publi c.sqlserver.ser ver.
--
Hope this helps.
Dan Guzman
SQL Server MVP http://weblogs.sqlteam.com/dang/
"Erland Sommarskog" <es****@sommars kog.sewrote in message
news:Xn******** **************@ 127.0.0.1...
Andres Rormoser (ar*******@gmai l.com) writes:
>I'm using SQL Server 2000 8.00.2039.
I finnaly solve the problem!! The clasic restart! I restarted the SQL
Server and now it's working in 15s like it should.
No, that operation should run in far less than 15s if you coded
it properly. It's more difficult than on SQL 2005, but I'm still
prepare to take the challenge if I get the tables and data to play
with.
>Now, my question is why? It's a good practice to restart SQL server
every x days? Memory related issues? Is there any DBCC command to
"clean" memory?
No, it's definitely not a good idea to restart SQL Server on regular
basis. That is just a waste of time.
It sounds that you simply were the victim of a poor execution plan.
When SQL Server first biulds the execition for a function or a stored
procedure, it sniffs the input parameters and uses these values as
guidance. If the first call is with atypical parameters, this can lead
to a less good plan for the common case. In such case you could have
achieved the same result with sp_recompile on your function to flush
the plan for from the cache.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Andres, please don't post the same question independently to multiple groups
as this causes duplication of effort. Instead, post the question once with
cross-post to other relevant groups.
There is additional information waiting for you in the
microsoft.publi c.sqlserver.ser ver thread.
--
Hope this helps.
Dan Guzman
SQL Server MVP http://weblogs.sqlteam.com/dang/
"Andres Rormoser" <ar*******@gmai l.comwrote in message
news:6d******** *************** ***********@i7g 2000prf.googleg roups.com...
I'm having a performance Issue with my Production SQL Server (2 x Xeon
Dual-Core Woodcrest 1.6Ghz, 2GB RAM, IIS, SQL Server). In general the
querys take much longer than the querys in my development server . For
example a recursive UDF takes 20s in my development server and 2m in
my production server (both with same users load) but my production
server it's much hardware powerfull than the other server.
I start monitoring an realized that the Prod. Server consumes a lot of
Physical Disk Reads and Writes when i execute this example UDF query,
then I realized that the Prod. Server has a SATA RAID1 Disk Mirroring
and my Dev. Server do not has mirroring.
It seems that the RAID1 disk performance seems to be very important
when I execute this query, and my question is WHY??
If the query only reads one Table 'CentroCostos' witch has 1255
records, why DISK performance is so important? It should work with
this info on memory and not have to use so much disk i/o.
Please help me understand this to solve this problem.
Thanks, AR
SET QUOTED_IDENTIFI ER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCo sto (@ccs_ids VARCHAR(4000))
RETURNS @Ret TABLE (ccs_id INT)
AS
BEGIN
DECLARE @ccs_ccs_id INT, @cantidad INT, @ccs_id INT
IF @ccs_ids = 'null'
RETURN
SELECT @cantidad = COUNT(*) FROM dbo.fn_split(@c cs_ids,',')
IF @cantidad = 1
BEGIN
SELECT @cantidad = COUNT(*) FROM CentroCosto WHERE ccs_ccs_id
= @ccs_ids
IF @cantidad = 0
BEGIN
INSERT INTO @Ret SELECT @ccs_ids
RETURN
END
ELSE
BEGIN
INSERT INTO @Ret SELECT @ccs_ids
DECLARE ListadoCcs CURSOR FOR ( SELECT ccs_id FROM
CentroCosto WHERE ccs_ccs_id = @ccs_ids )
OPEN ListadoCcs
FETCH NEXT FROM ListadoCcs INTO @ccs_id
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO
@Ret
SELECT
a.ccs_id
FROM
dbo.fn_CentroCo sto(@ccs_id) As a
FETCH NEXT FROM ListadoCcs INTO @ccs_id
END
CLOSE ListadoCcs
DEALLOCATE ListadoCcs
END
END
ELSE
BEGIN
DECLARE ListadoCcs CURSOR FOR ( SELECT a.Value FROM
dbo.fn_split(@c cs_ids,',') AS a )
OPEN ListadoCcs
FETCH NEXT FROM ListadoCcs INTO @ccs_id
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO
@Ret
SELECT
ccs_id
FROM
dbo.fn_CentroCo sto(@ccs_id)
WHERE
ccs_id not in (select ccs_id from
@Ret)
FETCH NEXT FROM ListadoCcs INTO @ccs_id
END
CLOSE ListadoCcs
DEALLOCATE ListadoCcs
END
RETURN
END
go
SET ANSI_NULLS OFF
go
SET QUOTED_IDENTIFI ER OFF
go
IF OBJECT_ID('dbo. fn_CentroCosto' ) IS NOT NULL
PRINT '<<< CREATED FUNCTION dbo.fn_CentroCo sto >>>'
ELSE
PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCo sto >>>'
go
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Lorax |
last post by:
I'm on the IS team of a medium-sized non-profit with international
reach. We're trying to make some decisions regarding our Web server
and database server as we expand our web site to have more dynamic
content. Currently the database server houses all data pertinent to
the organization (membership data, events, products, etc) in one
database (~2.2 GB) as well as the web site content in a separate
database (~40 MB). The web site pulls from...
|
by: Andrew Mayo |
last post by:
This problem was discovered with MSDE2000 SP2 and under WinXP SP2. We
are unsure whether it is more widespread as it has only been seen on
one machine to date.
The problem is related to name resolution. If you attempt to connect
to a local database with a connect string using
server=.
rather than
|
by: smileydip |
last post by:
I have a performance and memory management issues with SQL SERVER. I
feel SQL server does not releases the unused memory back to the OS. I
have been monitoring that at the end of the day the SQL SERVER
performance gets really bad. And it this point it has acquired all the
Cache it could. I have abt 4 GB of RAM on my server and out of it SQL
SERVER uses almost 2.7 GB whether there is load on the machine or not.
If there any way or tool to...
|
by: David W. Fenton |
last post by:
A client is panicking about their large Access application, which
has been running smoothly with 100s of thousands of records for
quite some time. They have a big project in the next year that will
lead to a lot of use of the database and the adding of quite a lot
of new data (though I can't conceive of them adding more than than
10s of thousands of records, which won't change the current
performance profile at all).
If there is a SQL...
|
by: Dhilip Kumar |
last post by:
Hi all,
I have developed a windows service using the windows service project
template in VS.NET. I have used three controls in the service, a timer,
performance counter and a message queue control. The service will "sleep"
for 'n' seconds using the timer control and whenever the timer_elapsed event
occurs, I use the performance counter object to determine availability of
few resources. Based on the availability of resources, I use the...
| | |
by: Daniel Walzenbach |
last post by:
Hi,
I have a web application which sometimes throws an “out of memory”
exception. To get an idea what happens I traced some values using performance
monitor and got the following values (for one day):
\\FFDS24\ASP.NET Applications(_LM_W3SVC_1_Root_ATV2004)\Errors During
Execution: 7
\\FFDS24\ASP.NET Apps v1.1.4322(_LM_W3SVC_1_Root_ATV2004)\Compilations
|
by: chicken butt |
last post by:
Hi -
I am trying to move some of my web apps from my development machine
running XP PRO SP2 to one of our Windows 2000 server boxes. I have
created a new site for each of the apps and am using Host Headers to
differentiate between them all.
In IIS, if I redirect to another server running Windows 2003 Server,
the 2.0 applications work very well.
|
by: Geoff McElhanon |
last post by:
I have been struggling with a security issue that occurs under .NET
2.0, but does not occur under .NET 1.1. Essentially I am trying to
open up a performance counter on a remote server and monitor its value.
In .NET 1.1 this worked fine, however under .NET 2.0 it fails when I
am not an administrator on the remote server.
To provide a lean demonstration of the issue, I created the following
class:
============================
|
by: dunleav1 |
last post by:
I built a test job that loads data into the database. I get great
performance with Oracle and I'm trying to tune Sql Server to get the
same type of performance.
Based on system monitoring it looks like an I/O issue. So I started
investigating based on sql server perfromance tuning technical
reference.
Here are my system monitor findings:
The system monitor shows during my job:
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
