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_IDENTIFIER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCosto (@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(@ccs_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_CentroCosto(@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(@ccs_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_CentroCosto(@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_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.fn_CentroCosto') IS NOT NULL
PRINT '<<< CREATED FUNCTION dbo.fn_CentroCosto >>>'
ELSE
PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCosto >>>'
go
7  1758 
Firstly , could you confirm the 2 dbs are similar in terms of
indices,statistics 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*******@gmail.comwrote in message
news:6d**********************************@i7g2000p rf.googlegroups.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_IDENTIFIER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCosto (@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(@ccs_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_CentroCosto(@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(@ccs_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_CentroCosto(@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_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.fn_CentroCosto') IS NOT NULL
PRINT '<<< CREATED FUNCTION dbo.fn_CentroCosto >>>'
ELSE
PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCosto >>>'
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...@del.comwrote:
Firstly , could you confirm the 2 dbs are similar in terms of
indices,statistics 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...@gmail.comwrote in message
news:6d**********************************@i7g2000p rf.googlegroups.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_IDENTIFIER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCosto (@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(@ccs_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_CentroCosto(@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(@ccs_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_CentroCosto(@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_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.fn_CentroCosto') IS NOT NULL
* *PRINT '<<< CREATED FUNCTION dbo.fn_CentroCosto >>>'
ELSE
* *PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCosto >>>'
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...@gmail.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...@del.comwrote:
Firstly , could you confirm the 2 dbs are similar in terms of
indices,statistics 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...@gmail.comwrote in message
news:6d**********************************@i7g2000p rf.googlegroups.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_IDENTIFIER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCosto (@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(@ccs_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_CentroCosto(@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(@ccs_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_CentroCosto(@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_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.fn_CentroCosto') IS NOT NULL
* *PRINT '<<< CREATED FUNCTION dbo.fn_CentroCosto >>>'
ELSE
* *PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCosto >>>'
go- Ocultar texto de la cita -
- Mostrar texto de la cita -- Ocultar texto de la cita -
- Mostrar texto de la cita -
Andres Rormoser (ar*******@gmail.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****@sommarskog.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.public.sqlserver.server.
--
Hope this helps.
Dan Guzman
SQL Server MVP http://weblogs.sqlteam.com/dang/
"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...
Andres Rormoser (ar*******@gmail.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****@sommarskog.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.public.sqlserver.server thread.
--
Hope this helps.
Dan Guzman
SQL Server MVP http://weblogs.sqlteam.com/dang/
"Andres Rormoser" <ar*******@gmail.comwrote in message
news:6d**********************************@i7g2000p rf.googlegroups.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_IDENTIFIER OFF
go
SET ANSI_NULLS OFF
go
CREATE FUNCTION dbo.fn_CentroCosto (@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(@ccs_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_CentroCosto(@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(@ccs_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_CentroCosto(@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_IDENTIFIER OFF
go
IF OBJECT_ID('dbo.fn_CentroCosto') IS NOT NULL
PRINT '<<< CREATED FUNCTION dbo.fn_CentroCosto >>>'
ELSE
PRINT '<<< FAILED CREATING FUNCTION dbo.fn_CentroCosto >>>'
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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,...
|
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...
| |
