Is there any tools to collect the sql statment run information and run log?

For our coming performance tuning and trace which happen on some query is so
slow, we need to collect all sql statements run and time spending to run
log. Is there any tools help we to collect it?
SQL Profiler (Start\Run\Microsoft SQL Server 2005\Performance Tools)
If it's not there, then install Client Tools\Management Tools from the SQL
Server media.
Ekrem nsoy
"ABC" <abc@.abc.com> wrote in message
news:OiQPVjKOIHA.3940@.TK2MSFTNGP05.phx.gbl...
> For our coming performance tuning and trace which happen on some query is
> so slow, we need to collect all sql statements run and time spending to
> run log. Is there any tools help we to collect it?
>
>

Is there any tools to collect the sql statment run information and run log?

For our coming performance tuning and trace which happen on some query is so
slow, we need to collect all sql statements run and time spending to run
log. Is there any tools help we to collect it?SQL Profiler (Start\Run\Microsoft SQL Server 2005\Performance Tools)
If it's not there, then install Client Tools\Management Tools from the SQL
Server media.
Ekrem nsoy
"ABC" <abc@.abc.com> wrote in message
news:OiQPVjKOIHA.3940@.TK2MSFTNGP05.phx.gbl...
> For our coming performance tuning and trace which happen on some query is
> so slow, we need to collect all sql statements run and time spending to
> run log. Is there any tools help we to collect it?
>
>

Is there any tools to collect the sql statment run information and run log?

For our coming performance tuning and trace which happen on some query is so
slow, we need to collect all sql statements run and time spending to run
log. Is there any tools help we to collect it?SQL Profiler (Start\Run\Microsoft SQL Server 2005\Performance Tools)
If it's not there, then install Client Tools\Management Tools from the SQL
Server media.
--
Ekrem Önsoy
"ABC" <abc@.abc.com> wrote in message
news:OiQPVjKOIHA.3940@.TK2MSFTNGP05.phx.gbl...
> For our coming performance tuning and trace which happen on some query is
> so slow, we need to collect all sql statements run and time spending to
> run log. Is there any tools help we to collect it?
>
>

is there any tools in the Business Intelligence Studio which can be used as Rules Engine?

I want to create business Rules from BI Development Studio. This will be a replacement of creating Stored Procedure. Most of the Business Rules are in the form of Stored Procedures since the DB is based on SQL Server 2000, but, it's migrating to 2005 server, so, it would be ideal if something in the BI studio can do Business Rules.Moving to SQL Server Tools General forum.

is there any open source db tools for MSSQL ?

hi, good day, is there any good open source database tools available for mssql ? thank youThere is a good designer tool called DBDesigner4,you can check this out link (http://fabforce.net/downloads.php)

Is there any free tools taht I could read t sql 2005 log files

Hi,
I need to read sql2005 log files. Red gate has sql2000 one for free. I need
sql2005.
any ideas?
thanks
I don't of any free tools. As a matter of fact, they are pretty pricey since
people are usually in a bind when they go looking for them. However, I
believe they are just a gui on dbcc log so you could look into that command.
It is pretty cryptic though.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>
|||I tried. It desn't really tell me anything.
What I need is that It shows the sql stetement (update, select and delete
ect.. and user name....)
Thanks
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>I don't of any free tools. As a matter of fact, they are pretty pricey
>since people are usually in a bind when they go looking for them. However,
>I believe they are just a gui on dbcc log so you could look into that
>command. It is pretty cryptic though.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>
|||On Thu, 10 Apr 2008 15:59:48 -0400, Mecn wrote:

> I tried. It desn't really tell me anything.
> What I need is that It shows the sql stetement (update, select and delete
> ect.. and user name....)
> Thanks
The log does not store sql statements. It only stores information regarding
changes that were made to pages in the database (i.e. were rows
inserted/updated/deleted).
Thanks,
Marcel van der Holst
SQL Server Storage Engine Team.
[vbcol=seagreen]
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
|||Pay the money (surprisingly little, actually) for apexsql.com's Log product.
Every production environment should have a tool such as this available for
the 'holy-shit' times. Also helps trememdously during
debugging/troubleshooting scenarios too.
Disclaimer: I work closely with Apex, I use and promote their products to
my clients. If you tell them TheSQLGuru sent you you can pick up a nice
discount (and I will receive a small referral fee). They have a wide array
of very useful SQL Server-specific tools.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>

Is there any free tools taht I could read t sql 2005 log files

Hi,
I need to read sql2005 log files. Red gate has sql2000 one for free. I need
sql2005.
any ideas?
thanksI don't of any free tools. As a matter of fact, they are pretty pricey since
people are usually in a bind when they go looking for them. However, I
believe they are just a gui on dbcc log so you could look into that command.
It is pretty cryptic though.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>|||I tried. It desn't really tell me anything.
What I need is that It shows the sql stetement (update, select and delete
ect.. and user name....)
Thanks
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>I don't of any free tools. As a matter of fact, they are pretty pricey
>since people are usually in a bind when they go looking for them. However,
>I believe they are just a gui on dbcc log so you could look into that
>command. It is pretty cryptic though.
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>|||On Thu, 10 Apr 2008 15:59:48 -0400, Mecn wrote:
> I tried. It desn't really tell me anything.
> What I need is that It shows the sql stetement (update, select and delete
> ect.. and user name....)
> Thanks
The log does not store sql statements. It only stores information regarding
changes that were made to pages in the database (i.e. were rows
inserted/updated/deleted).
Thanks,
Marcel van der Holst
SQL Server Storage Engine Team.
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:eAPgbG0mIHA.944@.TK2MSFTNGP05.phx.gbl...
>>I don't of any free tools. As a matter of fact, they are pretty pricey
>>since people are usually in a bind when they go looking for them. However,
>>I believe they are just a gui on dbcc log so you could look into that
>>command. It is pretty cryptic though.
>> --
>> Jason Massie
>> Web: http://statisticsio.com
>> RSS: http://feeds.feedburner.com/statisticsio
>> "Mecn" <mecn@.yahoo.com> wrote in message
>> news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> I need to read sql2005 log files. Red gate has sql2000 one for free. I
>> need sql2005.
>> any ideas?
>> thanks
>>|||Pay the money (surprisingly little, actually) for apexsql.com's Log product.
Every production environment should have a tool such as this available for
the 'holy-shit' times. Also helps trememdously during
debugging/troubleshooting scenarios too.
Disclaimer: I work closely with Apex, I use and promote their products to
my clients. If you tell them TheSQLGuru sent you you can pick up a nice
discount (and I will receive a small referral fee). They have a wide array
of very useful SQL Server-specific tools.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oa4fN9zmIHA.3532@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I need to read sql2005 log files. Red gate has sql2000 one for free. I
> need sql2005.
> any ideas?
> thanks
>

Is there an OWC forum here or anywhere?

“It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issues such as yours. Here is a link to resources that will help you: http://msdn.microsoft.com/office”

Thanks,

George

Hi,friends, please help me. I can't find out an OWC forumn here. Many people have interest in OWC and asked some questions. But the answer is always that here is not an OWC forum.

MMM....

Is there an OWC forum here or anywhere?

Anyone could give me a tip? thanks!