Concatenating fields: log

Showing posts with label log. Show all posts

Friday, February 24, 2012

condensing log files

I need to set up an automated way to condense log files in a database. I
successfully got a "dbcc shrinkdatabase" command to run in TranSQL, but I
was thinking that if I can create a stored proc that runs through all the
tables in a dabase, I could schedule that to run and it would always keep my
log file sizes down. So I wrote code, but of course the first parameter of
the "dbcc shrinkdatabase" command requires a 'table object' and that is my
problem. How can I write the code to use the table names as table objects
instead of varchar vairables? Here is the code that I have so far:
declare @.name as varchar(50)
create table #tableNames
(name varchar(50))
insert into #tableNames select TABLE_NAME from INFORMATION_SCHEMA.TABLES
while select count(*) from #tableNames > 0
BEGIN
@.name = select top 1 from #tableNames
dbcc shrinkdatabase (@.name, truncateonly)
delete from #tableNames where name = @.name
END
drop table #tableNames
Scott Schuman
Medical AssociatesThere are undocumented stored procedures designed to execute dynamic SQL
against databases and tables:
Undocumented sp_MSforeachdb and sp_MSforeachtable Stored Procedures
http://www.dbazine.com/sql/sql-articles/larsen5
"Schoo" <scott.schuman@.nospam.ma-hc.com> wrote in message
news:OnHXUDD$FHA.1548@.TK2MSFTNGP10.phx.gbl...
>I need to set up an automated way to condense log files in a database. I
> successfully got a "dbcc shrinkdatabase" command to run in TranSQL, but I
> was thinking that if I can create a stored proc that runs through all the
> tables in a dabase, I could schedule that to run and it would always keep
> my
> log file sizes down. So I wrote code, but of course the first parameter
> of
> the "dbcc shrinkdatabase" command requires a 'table object' and that is my
> problem. How can I write the code to use the table names as table objects
> instead of varchar vairables? Here is the code that I have so far:
> declare @.name as varchar(50)
> create table #tableNames
> (name varchar(50))
> insert into #tableNames select TABLE_NAME from INFORMATION_SCHEMA.TABLES
> while select count(*) from #tableNames > 0
> BEGIN
> @.name = select top 1 from #tableNames
> dbcc shrinkdatabase (@.name, truncateonly)
> delete from #tableNames where name = @.name
> END
> drop table #tableNames
> Scott Schuman
> Medical Associates
>|||Schoo (scott.schuman@.nospam.ma-hc.com) writes:
> I need to set up an automated way to condense log files in a database.
> I successfully got a "dbcc shrinkdatabase" command to run in TranSQL,
> but I was thinking that if I can create a stored proc that runs through
> all the tables in a dabase, I could schedule that to run and it would
> always keep my log file sizes down. So I wrote code, but of course the
> first parameter of the "dbcc shrinkdatabase" command requires a 'table
> object' and that is my problem. How can I write the code to use the
> table names as table objects instead of varchar vairables? Here is the
> code that I have so far:
It seems to me to be a poor idea. Shrinking is good if a file has
exploded because a of some special operation. But shrinking the log
regularly is meaningless, the log will grow again, and that will cost
you performance.
Also read this article from Tibor Karazsi's site:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Sunday, February 19, 2012

Concurrent query problem

hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani Omar
You are running either MSDE or Personal Edition and have hit the roof of that edition. I.e., the performance
throttling has kicked in. This is a good indication that you want to move to Standard or Enterprise Edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 oB.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>
|||You are running either MSDE or SQL Server 2000 Professional. These have
been optimized for 8 concurrently running queries and performance degrades
when you have more queries running at the same time. Either you can space
out your queries so that fewer are running concurrently or you can upgrade
to a server version of SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani Omar
|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>
|||Run:
select serverproperty ('Edition')
and post the results.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>
|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can[vbcol=seagreen]
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade
> has
>
|||Why didn't you run the query I gave you?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eN3PbxHKEHA.2452@.TK2MSFTNGP09.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can[vbcol=seagreen]
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade
> has
>
|||result:
Personal Edition
Sorry, how can I upgrade it to the standard edition?
What is the difference between the Standard and Enterprise edition?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can[vbcol=seagreen]
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade
> has
>
|||http://www.microsoft.com/sql/techinf...skChooseEd.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> result:
> Personal Edition
> Sorry, how can I upgrade it to the standard edition?
> What is the difference between the Standard and Enterprise edition?
> Thank you
> Milani Omar
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> can
> degrades
> space
> upgrade
>
|||Hello,
how can I upgrade it to standard edition. We have buyed bevore the license
for satandard edition but I have installed the pro edition erroneously.
Thank you
Milani Omar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> http://www.microsoft.com/sql/techinf...skChooseEd.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Milani Omar" <omar@.tio.ch> wrote in message
news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
How[vbcol=seagreen]
have[vbcol=seagreen]
of[vbcol=seagreen]
limit[vbcol=seagreen]
affected.
>

Concurrent query problem

hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani OmarYou are running either MSDE or Personal Edition and have hit the roof of tha
t edition. I.e., the performance
throttling has kicked in. This is a good indication that you want to move to
Standard or Enterprise Edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...[v
bcol=seagreen]
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit ha
s
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 oB.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>[/vbcol]|||You are running either MSDE or SQL Server 2000 Professional. These have
been optimized for 8 concurrently running queries and performance degrades
when you have more queries running at the same time. Either you can space
out your queries so that fewer are running concurrently or you can upgrade
to a server version of SQL Server.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani Omar|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Run:
select serverproperty ('Edition')
and post the results.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade[vbcol=seagreen]
> has
>|||Why didn't you run the query I gave you?
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eN3PbxHKEHA.2452@.TK2MSFTNGP09.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade[vbcol=seagreen]
> has
>|||result:
Personal Edition
Sorry, how can I upgrade it to the standard edition?
What is the difference between the Standard and Enterprise edition?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade[vbcol=seagreen]
> has
>|||http://www.microsoft.com/sql/techin...eskChooseEd.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...

> result:
> Personal Edition
> Sorry, how can I upgrade it to the standard edition?
> What is the difference between the Standard and Enterprise edition?
> Thank you
> Milani Omar
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> can
> degrades
> space
> upgrade
>|||Hello,
how can I upgrade it to standard edition. We have buyed bevore the license
for satandard edition but I have installed the pro edition erroneously.
Thank you
Milani Omar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> http://www.microsoft.com/sql/techin...eskChooseEd.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Milani Omar" <omar@.tio.ch> wrote in message
news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
How[vbcol=seagreen]
have[vbcol=seagreen]
of[vbcol=seagreen]
limit[vbcol=seagreen]
affected.[vbcol=seagreen]
>

Concurrent query problem

hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
--
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 ?B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
--
can someone help me please?
Thank you
Milani OmarYou are running either MSDE or Personal Edition and have hit the roof of that edition. I.e., the performance
throttling has kicked in. This is a good indication that you want to move to Standard or Enterprise Edition.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 oB.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||You are running either MSDE or SQL Server 2000 Professional. These have
been optimized for 8 concurrently running queries and performance degrades
when you have more queries running at the same time. Either you can space
out your queries so that fewer are running concurrently or you can upgrade
to a server version of SQL Server.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
--
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 ?B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
--
can someone help me please?
Thank you
Milani Omar|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Run:
select serverproperty ('Edition')
and post the results.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > You are running either MSDE or SQL Server 2000 Professional. These have
> > been optimized for 8 concurrently running queries and performance
degrades
> > when you have more queries running at the same time. Either you can
space
> > out your queries so that fewer are running concurrently or you can
upgrade
> > to a server version of SQL Server.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > hello,
> > I have an SQL SERVER 2000.
> > sometimes this server become slow. In the event log I see this king of
> > informations:
> >
> > --
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 22.04.2004
> > Time: 15:01:12
> > User: N/A
> > Computer: ***
> > Description:
> > 17052 :
> > This SQL Server has been optimized for 8 concurrent queries. This limit
> has
> > been exceeded by 1 queries and performance may be adversely affected.
> >
> > Data:
> > 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > 0010: 4c 00 00 00 07 00 00 00 L......
> > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > 0020: 65 00 72 00 00 00 e.r...
> >
> > --
> >
> > can someone help me please?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
>|||Why didn't you run the query I gave you?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eN3PbxHKEHA.2452@.TK2MSFTNGP09.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > You are running either MSDE or SQL Server 2000 Professional. These have
> > been optimized for 8 concurrently running queries and performance
degrades
> > when you have more queries running at the same time. Either you can
space
> > out your queries so that fewer are running concurrently or you can
upgrade
> > to a server version of SQL Server.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > hello,
> > I have an SQL SERVER 2000.
> > sometimes this server become slow. In the event log I see this king of
> > informations:
> >
> > --
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 22.04.2004
> > Time: 15:01:12
> > User: N/A
> > Computer: ***
> > Description:
> > 17052 :
> > This SQL Server has been optimized for 8 concurrent queries. This limit
> has
> > been exceeded by 1 queries and performance may be adversely affected.
> >
> > Data:
> > 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > 0010: 4c 00 00 00 07 00 00 00 L......
> > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > 0020: 65 00 72 00 00 00 e.r...
> >
> > --
> >
> > can someone help me please?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
>|||result:
Personal Edition
Sorry, how can I upgrade it to the standard edition?
What is the difference between the Standard and Enterprise edition?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > You are running either MSDE or SQL Server 2000 Professional. These have
> > been optimized for 8 concurrently running queries and performance
degrades
> > when you have more queries running at the same time. Either you can
space
> > out your queries so that fewer are running concurrently or you can
upgrade
> > to a server version of SQL Server.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > hello,
> > I have an SQL SERVER 2000.
> > sometimes this server become slow. In the event log I see this king of
> > informations:
> >
> > --
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 22.04.2004
> > Time: 15:01:12
> > User: N/A
> > Computer: ***
> > Description:
> > 17052 :
> > This SQL Server has been optimized for 8 concurrent queries. This limit
> has
> > been exceeded by 1 queries and performance may be adversely affected.
> >
> > Data:
> > 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > 0010: 4c 00 00 00 07 00 00 00 L......
> > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > 0020: 65 00 72 00 00 00 e.r...
> >
> > --
> >
> > can someone help me please?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
>|||http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> result:
> Personal Edition
> Sorry, how can I upgrade it to the standard edition?
> What is the difference between the Standard and Enterprise edition?
> Thank you
> Milani Omar
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> > Run:
> >
> > select serverproperty ('Edition')
> >
> > and post the results.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> > I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
> can
> > I see witch version I'm running?
> >
> >
> > Thank you
> > Milani Omar
> >
> >
> >
> >
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > > You are running either MSDE or SQL Server 2000 Professional. These have
> > > been optimized for 8 concurrently running queries and performance
> degrades
> > > when you have more queries running at the same time. Either you can
> space
> > > out your queries so that fewer are running concurrently or you can
> upgrade
> > > to a server version of SQL Server.
> > >
> > > --
> > > Tom
> > >
> > > ---
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > SQL Server MVP
> > > Columnist, SQL Server Professional
> > > Toronto, ON Canada
> > > www.pinnaclepublishing.com/sql
> > >
> > >
> > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > > hello,
> > > I have an SQL SERVER 2000.
> > > sometimes this server become slow. In the event log I see this king of
> > > informations:
> > >
> > > --
> > >
> > > Event Type: Information
> > > Event Source: MSSQLSERVER
> > > Event Category: (2)
> > > Event ID: 17055
> > > Date: 22.04.2004
> > > Time: 15:01:12
> > > User: N/A
> > > Computer: ***
> > > Description:
> > > 17052 :
> > > This SQL Server has been optimized for 8 concurrent queries. This limit
> > has
> > > been exceeded by 1 queries and performance may be adversely affected.
> > >
> > > Data:
> > > 0000: 9c 42 00 00 0a 00 00 00 oB.....
> > > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > > 0010: 4c 00 00 00 07 00 00 00 L......
> > > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > > 0020: 65 00 72 00 00 00 e.r...
> > >
> > > --
> > >
> > > can someone help me please?
> > >
> > > Thank you
> > > Milani Omar
> > >
> > >
> > >
> >
> >
>|||Hello,
how can I upgrade it to standard edition. We have buyed bevore the license
for satandard edition but I have installed the pro edition erroneously.
Thank you
Milani Omar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Milani Omar" <omar@.tio.ch> wrote in message
news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> > result:
> > Personal Edition
> >
> > Sorry, how can I upgrade it to the standard edition?
> >
> > What is the difference between the Standard and Enterprise edition?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> > > Run:
> > >
> > > select serverproperty ('Edition')
> > >
> > > and post the results.
> > >
> > > --
> > > Tom
> > >
> > > ---
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > SQL Server MVP
> > > Columnist, SQL Server Professional
> > > Toronto, ON Canada
> > > www.pinnaclepublishing.com/sql
> > >
> > >
> > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > > Hello,
> > > I'm running che SQL Server 2000 Standard edition. But I'm not sure.
How
> > can
> > > I see witch version I'm running?
> > >
> > >
> > > Thank you
> > > Milani Omar
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > > news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > > > You are running either MSDE or SQL Server 2000 Professional. These
have
> > > > been optimized for 8 concurrently running queries and performance
> > degrades
> > > > when you have more queries running at the same time. Either you can
> > space
> > > > out your queries so that fewer are running concurrently or you can
> > upgrade
> > > > to a server version of SQL Server.
> > > >
> > > > --
> > > > Tom
> > > >
> > > > ---
> > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > > SQL Server MVP
> > > > Columnist, SQL Server Professional
> > > > Toronto, ON Canada
> > > > www.pinnaclepublishing.com/sql
> > > >
> > > >
> > > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > > > hello,
> > > > I have an SQL SERVER 2000.
> > > > sometimes this server become slow. In the event log I see this king
of
> > > > informations:
> > > >
> > > > --
> > > >
> > > > Event Type: Information
> > > > Event Source: MSSQLSERVER
> > > > Event Category: (2)
> > > > Event ID: 17055
> > > > Date: 22.04.2004
> > > > Time: 15:01:12
> > > > User: N/A
> > > > Computer: ***
> > > > Description:
> > > > 17052 :
> > > > This SQL Server has been optimized for 8 concurrent queries. This
limit
> > > has
> > > > been exceeded by 1 queries and performance may be adversely
affected.
> > > >
> > > > Data:
> > > > 0000: 9c 42 00 00 0a 00 00 00 oB.....
> > > > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > > > 0010: 4c 00 00 00 07 00 00 00 L......
> > > > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > > > 0020: 65 00 72 00 00 00 e.r...
> > > >
> > > > --
> > > >
> > > > can someone help me please?
> > > >
> > > > Thank you
> > > > Milani Omar
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Milani,
SQL2000 personal edition can be upgraded to SQL2000 standard edition.Refer
the below snippet from BooksOnLine topic 'Upgrading an Existing Installation
of SQL Server' for the upgrade procedure:
<begin quote>
How to perform an edition upgrade within SQL Server 2000 (Setup)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
<end quote>
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Milani Omar" <omar@.tio.ch> wrote in message
news:#bGzToIKEHA.1272@.tk2msftngp13.phx.gbl...
> Hello,
> how can I upgrade it to standard edition. We have buyed bevore the license
> for satandard edition but I have installed the pro edition erroneously.
> Thank you
> Milani Omar
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
> scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> > http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> > > result:
> > > Personal Edition
> > >
> > > Sorry, how can I upgrade it to the standard edition?
> > >
> > > What is the difference between the Standard and Enterprise edition?
> > >
> > > Thank you
> > > Milani Omar
> > >
> > >
> > >
> > >
> > > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > > news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> > > > Run:
> > > >
> > > > select serverproperty ('Edition')
> > > >
> > > > and post the results.
> > > >
> > > > --
> > > > Tom
> > > >
> > > > ---
> > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > > SQL Server MVP
> > > > Columnist, SQL Server Professional
> > > > Toronto, ON Canada
> > > > www.pinnaclepublishing.com/sql
> > > >
> > > >
> > > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > > news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > > > Hello,
> > > > I'm running che SQL Server 2000 Standard edition. But I'm not sure.
> How
> > > can
> > > > I see witch version I'm running?
> > > >
> > > >
> > > > Thank you
> > > > Milani Omar
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > > > news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > > > > You are running either MSDE or SQL Server 2000 Professional.
These
> have
> > > > > been optimized for 8 concurrently running queries and performance
> > > degrades
> > > > > when you have more queries running at the same time. Either you
can
> > > space
> > > > > out your queries so that fewer are running concurrently or you can
> > > upgrade
> > > > > to a server version of SQL Server.
> > > > >
> > > > > --
> > > > > Tom
> > > > >
> > > > > ---
> > > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > > > SQL Server MVP
> > > > > Columnist, SQL Server Professional
> > > > > Toronto, ON Canada
> > > > > www.pinnaclepublishing.com/sql
> > > > >
> > > > >
> > > > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > > > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > > > > hello,
> > > > > I have an SQL SERVER 2000.
> > > > > sometimes this server become slow. In the event log I see this
king
> of
> > > > > informations:
> > > > >
> > > > > --
> > > > >
> > > > > Event Type: Information
> > > > > Event Source: MSSQLSERVER
> > > > > Event Category: (2)
> > > > > Event ID: 17055
> > > > > Date: 22.04.2004
> > > > > Time: 15:01:12
> > > > > User: N/A
> > > > > Computer: ***
> > > > > Description:
> > > > > 17052 :
> > > > > This SQL Server has been optimized for 8 concurrent queries. This
> limit
> > > > has
> > > > > been exceeded by 1 queries and performance may be adversely
> affected.
> > > > >
> > > > > Data:
> > > > > 0000: 9c 42 00 00 0a 00 00 00 oB.....
> > > > > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > > > > 0010: 4c 00 00 00 07 00 00 00 L......
> > > > > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > > > > 0020: 65 00 72 00 00 00 e.r...
> > > > >
> > > > > --
> > > > >
> > > > > can someone help me please?
> > > > >
> > > > > Thank you
> > > > > Milani Omar
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Concurrent queries error

On my server running SQL Server 2000 (SP3). I frequently get this
informational message in the Event Viewer log.

17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 2 queries and performance may be adversely affected.

The application that I am running is a vendor application so I do not have
access to the code. I contacted the vendor, but they have never seen this
problem and cannot recreate it. I checked the Microsoft Knowledge Base for
help, but I came up empty. It seems like it should be a simple
configuration change.

Any advice?
Thanks,
JeffI found the answer many times by just searching this site. Should have
done that first.

Go ahead and remove this thread.

Jeff

Concurrent queries

quote:

> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks

|||Jeanie,
Are you running either MSDE or Personal Edition of SQL Server? If so, these
are scaled down in size from the full SQL Server. Your choices would then
be:
1 - Accept the reduced performance
2 - In a development environment, upgrade to SQL Server Developer Edition
3 - In a production environment, upgrade to SQL Server Standard Edition
Russell Fields
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...

quote:

> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks

|||If you download the latest BOL update (January 2004) it has new material
specifically about the MSDE 2000 Workload Governor.
http://www.microsoft.com/sql/techin.../2000/books.asp
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...

quote:

> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks

|||Jacco
Is it relative easy to update the Personal Edition to Sql
Server Standard. Where can I find the white papers.
Thanks
Jeanie

quote:

>--Original Message--
>Hi Jeanie,
>You will only see that message on MSDE or SQL Server

Personal Edition, and

quote:

>it is a limitation built in to these (basically free)

versions, so that they

quote:

>can't be used for large systems. If you don't want to

see it anymore you

quote:

>will have to upgrade to SQL Server Standard Edition.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Jeanie" <jfhayes@.godwingruber.com> wrote in message
>news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...
I[QUOTE]
>
>.
>

|||Hi Jeanie,
It is fairly straightforward to do an edition upgrade of SQL Server. Just
make sure you back up all your databases first, including the master and
msdb databases.
See the topic "upgrading SQL Server, edition upgrades" for the details.
Jacco Schalkwijk
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:6eb301c3e6b7$5bb1f9e0$a501280a@.phx.gbl...[QUOTE]
> Jacco
> Is it relative easy to update the Personal Edition to Sql
> Server Standard. Where can I find the white papers.
> Thanks
> Jeanie
> Personal Edition, and
> versions, so that they
> see it anymore you
> I

Concurrent queries

Where do I change the setting for concurrent queries? I
keep seeing the following in my sql log.
This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 1 queries and
performance may be adversely affected.
ThanksHi Jeanie,
You will only see that message on MSDE or SQL Server Personal Edition, and
it is a limitation built in to these (basically free) versions, so that they
can't be used for large systems. If you don't want to see it anymore you
will have to upgrade to SQL Server Standard Edition.
--
Jacco Schalkwijk
SQL Server MVP
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...
> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks|||Jeanie,
Are you running either MSDE or Personal Edition of SQL Server? If so, these
are scaled down in size from the full SQL Server. Your choices would then
be:
1 - Accept the reduced performance
2 - In a development environment, upgrade to SQL Server Developer Edition
3 - In a production environment, upgrade to SQL Server Standard Edition
Russell Fields
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...
> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks|||If you download the latest BOL update (January 2004) it has new material
specifically about the MSDE 2000 Workload Governor.
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...
> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks|||Jacco
Is it relative easy to update the Personal Edition to Sql
Server Standard. Where can I find the white papers.
Thanks
Jeanie
>--Original Message--
>Hi Jeanie,
>You will only see that message on MSDE or SQL Server
Personal Edition, and
>it is a limitation built in to these (basically free)
versions, so that they
>can't be used for large systems. If you don't want to
see it anymore you
>will have to upgrade to SQL Server Standard Edition.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Jeanie" <jfhayes@.godwingruber.com> wrote in message
>news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...
>> Where do I change the setting for concurrent queries?
I
>> keep seeing the following in my sql log.
>>
>> This SQL Server has been optimized for 8 concurrent
>> queries. This limit has been exceeded by 1 queries and
>> performance may be adversely affected.
>> Thanks
>
>.
>|||Hi Jeanie,
It is fairly straightforward to do an edition upgrade of SQL Server. Just
make sure you back up all your databases first, including the master and
msdb databases.
See the topic "upgrading SQL Server, edition upgrades" for the details.
Jacco Schalkwijk
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:6eb301c3e6b7$5bb1f9e0$a501280a@.phx.gbl...
> Jacco
> Is it relative easy to update the Personal Edition to Sql
> Server Standard. Where can I find the white papers.
> Thanks
> Jeanie
> >--Original Message--
> >Hi Jeanie,
> >
> >You will only see that message on MSDE or SQL Server
> Personal Edition, and
> >it is a limitation built in to these (basically free)
> versions, so that they
> >can't be used for large systems. If you don't want to
> see it anymore you
> >will have to upgrade to SQL Server Standard Edition.
> >
> >--
> >Jacco Schalkwijk
> >SQL Server MVP
> >
> >
> >"Jeanie" <jfhayes@.godwingruber.com> wrote in message
> >news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...
> >> Where do I change the setting for concurrent queries?
> I
> >> keep seeing the following in my sql log.
> >>
> >>
> >> This SQL Server has been optimized for 8 concurrent
> >> queries. This limit has been exceeded by 1 queries and
> >> performance may be adversely affected.
> >>
> >> Thanks
> >
> >
> >.
> >

Concurrent executions of "fn_trace_gettable" function are failing.

Hi,
While executing
select * from fn_trace_gettable('C:\Program Files\Microsoft SQL
Server\MSSQL.10\MSSQL\DATA\log.trc', default);
query simulateneously from multiple clients, only one
of them succeeds and all others give the following error message:
File 'C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc'
either does not exist or is not a recognizable trace file. Or there was an
error opening the file.
Seems like the "fn_trace_gettable" function is locking the trace log file
internally during it's execution. I do not have any alternative other than
executing the query simulateously from multiple clients. Can anyone suggest
a workaround for this problem?
Thanks,
NileshI haven't tested this myself, but definitely seems like a locking issue on
the file, and can see why that would be the case.
Can you load the file into one table first, and then use DTS to parallelly
copy that table to multiple locations?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Nilesh" <nilesh.oswal@.gmail.com> wrote in message
news:%23rXnKvzjEHA.3664@.TK2MSFTNGP12.phx.gbl...
Hi,
While executing
select * from fn_trace_gettable('C:\Program Files\Microsoft SQL
Server\MSSQL.10\MSSQL\DATA\log.trc', default);
query simulateneously from multiple clients, only one
of them succeeds and all others give the following error message:
File 'C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc'
either does not exist or is not a recognizable trace file. Or there was an
error opening the file.
Seems like the "fn_trace_gettable" function is locking the trace log file
internally during it's execution. I do not have any alternative other than
executing the query simulateously from multiple clients. Can anyone suggest
a workaround for this problem?
Thanks,
Nilesh|||Narayana,
I am firing this query from two datasets for generating a report (to be
deployed on SQL Reporting server). Unable to think of any workaround for
that. Any help would be greatly appreciated.
thanks,
Nilesh
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eOsdGr1jEHA.384@.TK2MSFTNGP10.phx.gbl...
> I haven't tested this myself, but definitely seems like a locking issue on
> the file, and can see why that would be the case.
> Can you load the file into one table first, and then use DTS to parallelly
> copy that table to multiple locations?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Nilesh" <nilesh.oswal@.gmail.com> wrote in message
> news:%23rXnKvzjEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Hi,
> While executing
> select * from fn_trace_gettable('C:\Program Files\Microsoft SQL
> Server\MSSQL.10\MSSQL\DATA\log.trc', default);
> query simulateneously from multiple clients, only one
> of them succeeds and all others give the following error message:
> File 'C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc'
> either does not exist or is not a recognizable trace file. Or there was an
> error opening the file.
> Seems like the "fn_trace_gettable" function is locking the trace log file
> internally during it's execution. I do not have any alternative other than
> executing the query simulateously from multiple clients. Can anyone
suggest
> a workaround for this problem?
> Thanks,
> Nilesh
>
>

Friday, February 17, 2012

Concurrent executions of "fn_trace_gettable" function are failing.

Hi,
While executing
select * from fn_trace_gettable('C:\Program Files\Microsoft SQL
Server\MSSQL.10\MSSQL\DATA\log.trc', default);
query simulateneously from multiple clients, only one
of them succeeds and all others give the following error message:
File 'C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc'
either does not exist or is not a recognizable trace file. Or there was an
error opening the file.
Seems like the "fn_trace_gettable" function is locking the trace log file
internally during it's execution. I do not have any alternative other than
executing the query simulateously from multiple clients. Can anyone suggest
a workaround for this problem?
Thanks,
Nilesh
I haven't tested this myself, but definitely seems like a locking issue on
the file, and can see why that would be the case.
Can you load the file into one table first, and then use DTS to parallelly
copy that table to multiple locations?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Nilesh" <nilesh.oswal@.gmail.com> wrote in message
news:%23rXnKvzjEHA.3664@.TK2MSFTNGP12.phx.gbl...
Hi,
While executing
select * from fn_trace_gettable('C:\Program Files\Microsoft SQL
Server\MSSQL.10\MSSQL\DATA\log.trc', default);
query simulateneously from multiple clients, only one
of them succeeds and all others give the following error message:
File 'C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc'
either does not exist or is not a recognizable trace file. Or there was an
error opening the file.
Seems like the "fn_trace_gettable" function is locking the trace log file
internally during it's execution. I do not have any alternative other than
executing the query simulateously from multiple clients. Can anyone suggest
a workaround for this problem?
Thanks,
Nilesh
|||Narayana,
I am firing this query from two datasets for generating a report (to be
deployed on SQL Reporting server). Unable to think of any workaround for
that. Any help would be greatly appreciated.
thanks,
Nilesh
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:eOsdGr1jEHA.384@.TK2MSFTNGP10.phx.gbl...
> I haven't tested this myself, but definitely seems like a locking issue on
> the file, and can see why that would be the case.
> Can you load the file into one table first, and then use DTS to parallelly
> copy that table to multiple locations?
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Nilesh" <nilesh.oswal@.gmail.com> wrote in message
> news:%23rXnKvzjEHA.3664@.TK2MSFTNGP12.phx.gbl...
> Hi,
> While executing
> select * from fn_trace_gettable('C:\Program Files\Microsoft SQL
> Server\MSSQL.10\MSSQL\DATA\log.trc', default);
> query simulateneously from multiple clients, only one
> of them succeeds and all others give the following error message:
> File 'C:\Program Files\Microsoft SQL Server\MSSQL.10\MSSQL\DATA\log.trc'
> either does not exist or is not a recognizable trace file. Or there was an
> error opening the file.
> Seems like the "fn_trace_gettable" function is locking the trace log file
> internally during it's execution. I do not have any alternative other than
> executing the query simulateously from multiple clients. Can anyone
suggest
> a workaround for this problem?
> Thanks,
> Nilesh
>
>

Friday, February 24, 2012

condensing log files

Sunday, February 19, 2012

Concurrent query problem

Concurrent query problem

Concurrent query problem

Concurrent queries error

Concurrent queries

Concurrent queries

Concurrent executions of "fn_trace_gettable" function are failing.

Friday, February 17, 2012

Concurrent executions of "fn_trace_gettable" function are failing.

Concurrent executions of "fn_trace_gettable" function are failing.

Concatenating fields

Blog Archive

About Me