I'm using the Client Tools installation.
The Open Table Query feature on a table (by right clicking on the table) is
rather userful for non-technical people as it is visual and one can easily
set up some queries without actually key in the SQL code.
Somehow I just can't find the features that I need :
(1) save this query so that I can reuse it. (Query Analyzer can do it but
then it is not visual)
(2) to output the result as a file in some path.(Again Query Analyzer can do
it )
Hope someone can share their experience on the above .> The Open Table Query feature on a table (by right clicking on the table)
> is
> rather userful for non-technical people as it is visual and one can easily
> set up some queries without actually key in the SQL code.
IMHO, Enterprise Manager is somewhere between non-technical and technical.
The query designer can help someone with cursory database knowledge retrieve
data but doesn't support some of the more advanced SQL constructs. This is
why many technical users prefer Query Analyzer.
Be aware that SQL Server client tools are not really intended to be used for
end-user ad-hoc reporting. Consider an application like Excel or the Report
Builder feature of SQL 2005 Reporting Services for end-user ad-hoc queries.
> (1) save this query so that I can reuse it. (Query Analyzer can do it but
> then it is not visual)
Copy/paste the generated SQL and save to a file. To reuse that query, paste
the SQL into a query designer SQL pane and click the check SQL syntax button
to refresh the GUI.
> (2) to output the result as a file in some path.(Again Query Analyzer can
> do
> it )
If you don't want to use QA for this task, you can copy the result grid,
paste into Excel and save in the format you prefer.
Hope this helps.
Dan Guzman
SQL Server MVP
"Delf" <Delf@.discussions.microsoft.com> wrote in message
news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
> I'm using the Client Tools installation.
> The Open Table Query feature on a table (by right clicking on the table)
> is
> rather userful for non-technical people as it is visual and one can easily
> set up some queries without actually key in the SQL code.
> Somehow I just can't find the features that I need :
> (1) save this query so that I can reuse it. (Query Analyzer can do it but
> then it is not visual)
> (2) to output the result as a file in some path.(Again Query Analyzer can
> do
> it )
> Hope someone can share their experience on the above .
>|||Thanks for the reply. Was expecting it to have a similar save as query and a
way of outputing directly.
One more question :
When right click on either the SQL or Diagram pane after Open Table Query,
there is a "Save As" and "Save" but when I click on them, there is no
response at all. Is that a bug ?
"Dan Guzman" wrote:
> IMHO, Enterprise Manager is somewhere between non-technical and technical.
> The query designer can help someone with cursory database knowledge retrie
ve
> data but doesn't support some of the more advanced SQL constructs. This i
s
> why many technical users prefer Query Analyzer.
> Be aware that SQL Server client tools are not really intended to be used f
or
> end-user ad-hoc reporting. Consider an application like Excel or the Repo
rt
> Builder feature of SQL 2005 Reporting Services for end-user ad-hoc queries
.
>
> Copy/paste the generated SQL and save to a file. To reuse that query, pas
te
> the SQL into a query designer SQL pane and click the check SQL syntax butt
on
> to refresh the GUI.
>
> If you don't want to use QA for this task, you can copy the result grid,
> paste into Excel and save in the format you prefer.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Delf" <Delf@.discussions.microsoft.com> wrote in message
> news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
>
>|||> When right click on either the SQL or Diagram pane after Open Table Query,
> there is a "Save As" and "Save" but when I click on them, there is no
> response at all. Is that a bug ?
This is documented behavior. From the SQL 2000 Books Online
<Excerpt
href="vdtsql.chm::/ _visual_database_tools_usage_considerati
ons.htm">
Although Query Designer provides menu options for saving, these options are
disabled.
</Excerpt>
The chapter also mentions the copy/paste method to print/save results and
queries. I believe the Query Designer tool is intended to be used as a
visual method to create SQL queries and not much else.
Hope this helps.
Dan Guzman
SQL Server MVP
"Delf" <Delf@.discussions.microsoft.com> wrote in message
news:C480D47F-F225-40CD-8FD3-E5252A1A97FA@.microsoft.com...[vbcol=seagreen]
> Thanks for the reply. Was expecting it to have a similar save as query and
> a
> way of outputing directly.
> One more question :
> When right click on either the SQL or Diagram pane after Open Table Query,
> there is a "Save As" and "Save" but when I click on them, there is no
> response at all. Is that a bug ?
>
> "Dan Guzman" wrote:
>
Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts
Wednesday, March 21, 2012
Open Table Query's Capabilities
I'm using the Client Tools installation.
The Open Table Query feature on a table (by right clicking on the table) is
rather userful for non-technical people as it is visual and one can easily
set up some queries without actually key in the SQL code.
Somehow I just can't find the features that I need :
(1) save this query so that I can reuse it. (Query Analyzer can do it but
then it is not visual)
(2) to output the result as a file in some path.(Again Query Analyzer can do
it )
Hope someone can share their experience on the above .> The Open Table Query feature on a table (by right clicking on the table)
> is
> rather userful for non-technical people as it is visual and one can easily
> set up some queries without actually key in the SQL code.
IMHO, Enterprise Manager is somewhere between non-technical and technical.
The query designer can help someone with cursory database knowledge retrieve
data but doesn't support some of the more advanced SQL constructs. This is
why many technical users prefer Query Analyzer.
Be aware that SQL Server client tools are not really intended to be used for
end-user ad-hoc reporting. Consider an application like Excel or the Report
Builder feature of SQL 2005 Reporting Services for end-user ad-hoc queries.
> (1) save this query so that I can reuse it. (Query Analyzer can do it but
> then it is not visual)
Copy/paste the generated SQL and save to a file. To reuse that query, paste
the SQL into a query designer SQL pane and click the check SQL syntax button
to refresh the GUI.
> (2) to output the result as a file in some path.(Again Query Analyzer can
> do
> it )
If you don't want to use QA for this task, you can copy the result grid,
paste into Excel and save in the format you prefer.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Delf" <Delf@.discussions.microsoft.com> wrote in message
news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
> I'm using the Client Tools installation.
> The Open Table Query feature on a table (by right clicking on the table)
> is
> rather userful for non-technical people as it is visual and one can easily
> set up some queries without actually key in the SQL code.
> Somehow I just can't find the features that I need :
> (1) save this query so that I can reuse it. (Query Analyzer can do it but
> then it is not visual)
> (2) to output the result as a file in some path.(Again Query Analyzer can
> do
> it )
> Hope someone can share their experience on the above .
>|||Thanks for the reply. Was expecting it to have a similar save as query and a
way of outputing directly.
One more question :
When right click on either the SQL or Diagram pane after Open Table Query,
there is a "Save As" and "Save" but when I click on them, there is no
response at all. Is that a bug ?
"Dan Guzman" wrote:
> > The Open Table Query feature on a table (by right clicking on the table)
> > is
> > rather userful for non-technical people as it is visual and one can easily
> > set up some queries without actually key in the SQL code.
> IMHO, Enterprise Manager is somewhere between non-technical and technical.
> The query designer can help someone with cursory database knowledge retrieve
> data but doesn't support some of the more advanced SQL constructs. This is
> why many technical users prefer Query Analyzer.
> Be aware that SQL Server client tools are not really intended to be used for
> end-user ad-hoc reporting. Consider an application like Excel or the Report
> Builder feature of SQL 2005 Reporting Services for end-user ad-hoc queries.
> > (1) save this query so that I can reuse it. (Query Analyzer can do it but
> > then it is not visual)
> Copy/paste the generated SQL and save to a file. To reuse that query, paste
> the SQL into a query designer SQL pane and click the check SQL syntax button
> to refresh the GUI.
> > (2) to output the result as a file in some path.(Again Query Analyzer can
> > do
> > it )
> If you don't want to use QA for this task, you can copy the result grid,
> paste into Excel and save in the format you prefer.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Delf" <Delf@.discussions.microsoft.com> wrote in message
> news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
> > I'm using the Client Tools installation.
> > The Open Table Query feature on a table (by right clicking on the table)
> > is
> > rather userful for non-technical people as it is visual and one can easily
> > set up some queries without actually key in the SQL code.
> >
> > Somehow I just can't find the features that I need :
> >
> > (1) save this query so that I can reuse it. (Query Analyzer can do it but
> > then it is not visual)
> >
> > (2) to output the result as a file in some path.(Again Query Analyzer can
> > do
> > it )
> >
> > Hope someone can share their experience on the above .
> >
>
>|||> When right click on either the SQL or Diagram pane after Open Table Query,
> there is a "Save As" and "Save" but when I click on them, there is no
> response at all. Is that a bug ?
This is documented behavior. From the SQL 2000 Books Online
<Excerpt
href="vdtsql.chm::/_visual_database_tools_usage_considerations.htm">
Although Query Designer provides menu options for saving, these options are
disabled.
</Excerpt>
The chapter also mentions the copy/paste method to print/save results and
queries. I believe the Query Designer tool is intended to be used as a
visual method to create SQL queries and not much else.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Delf" <Delf@.discussions.microsoft.com> wrote in message
news:C480D47F-F225-40CD-8FD3-E5252A1A97FA@.microsoft.com...
> Thanks for the reply. Was expecting it to have a similar save as query and
> a
> way of outputing directly.
> One more question :
> When right click on either the SQL or Diagram pane after Open Table Query,
> there is a "Save As" and "Save" but when I click on them, there is no
> response at all. Is that a bug ?
>
> "Dan Guzman" wrote:
>> > The Open Table Query feature on a table (by right clicking on the
>> > table)
>> > is
>> > rather userful for non-technical people as it is visual and one can
>> > easily
>> > set up some queries without actually key in the SQL code.
>> IMHO, Enterprise Manager is somewhere between non-technical and
>> technical.
>> The query designer can help someone with cursory database knowledge
>> retrieve
>> data but doesn't support some of the more advanced SQL constructs. This
>> is
>> why many technical users prefer Query Analyzer.
>> Be aware that SQL Server client tools are not really intended to be used
>> for
>> end-user ad-hoc reporting. Consider an application like Excel or the
>> Report
>> Builder feature of SQL 2005 Reporting Services for end-user ad-hoc
>> queries.
>> > (1) save this query so that I can reuse it. (Query Analyzer can do it
>> > but
>> > then it is not visual)
>> Copy/paste the generated SQL and save to a file. To reuse that query,
>> paste
>> the SQL into a query designer SQL pane and click the check SQL syntax
>> button
>> to refresh the GUI.
>> > (2) to output the result as a file in some path.(Again Query Analyzer
>> > can
>> > do
>> > it )
>> If you don't want to use QA for this task, you can copy the result grid,
>> paste into Excel and save in the format you prefer.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Delf" <Delf@.discussions.microsoft.com> wrote in message
>> news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
>> > I'm using the Client Tools installation.
>> > The Open Table Query feature on a table (by right clicking on the
>> > table)
>> > is
>> > rather userful for non-technical people as it is visual and one can
>> > easily
>> > set up some queries without actually key in the SQL code.
>> >
>> > Somehow I just can't find the features that I need :
>> >
>> > (1) save this query so that I can reuse it. (Query Analyzer can do it
>> > but
>> > then it is not visual)
>> >
>> > (2) to output the result as a file in some path.(Again Query Analyzer
>> > can
>> > do
>> > it )
>> >
>> > Hope someone can share their experience on the above .
>> >
>>sql
The Open Table Query feature on a table (by right clicking on the table) is
rather userful for non-technical people as it is visual and one can easily
set up some queries without actually key in the SQL code.
Somehow I just can't find the features that I need :
(1) save this query so that I can reuse it. (Query Analyzer can do it but
then it is not visual)
(2) to output the result as a file in some path.(Again Query Analyzer can do
it )
Hope someone can share their experience on the above .> The Open Table Query feature on a table (by right clicking on the table)
> is
> rather userful for non-technical people as it is visual and one can easily
> set up some queries without actually key in the SQL code.
IMHO, Enterprise Manager is somewhere between non-technical and technical.
The query designer can help someone with cursory database knowledge retrieve
data but doesn't support some of the more advanced SQL constructs. This is
why many technical users prefer Query Analyzer.
Be aware that SQL Server client tools are not really intended to be used for
end-user ad-hoc reporting. Consider an application like Excel or the Report
Builder feature of SQL 2005 Reporting Services for end-user ad-hoc queries.
> (1) save this query so that I can reuse it. (Query Analyzer can do it but
> then it is not visual)
Copy/paste the generated SQL and save to a file. To reuse that query, paste
the SQL into a query designer SQL pane and click the check SQL syntax button
to refresh the GUI.
> (2) to output the result as a file in some path.(Again Query Analyzer can
> do
> it )
If you don't want to use QA for this task, you can copy the result grid,
paste into Excel and save in the format you prefer.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Delf" <Delf@.discussions.microsoft.com> wrote in message
news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
> I'm using the Client Tools installation.
> The Open Table Query feature on a table (by right clicking on the table)
> is
> rather userful for non-technical people as it is visual and one can easily
> set up some queries without actually key in the SQL code.
> Somehow I just can't find the features that I need :
> (1) save this query so that I can reuse it. (Query Analyzer can do it but
> then it is not visual)
> (2) to output the result as a file in some path.(Again Query Analyzer can
> do
> it )
> Hope someone can share their experience on the above .
>|||Thanks for the reply. Was expecting it to have a similar save as query and a
way of outputing directly.
One more question :
When right click on either the SQL or Diagram pane after Open Table Query,
there is a "Save As" and "Save" but when I click on them, there is no
response at all. Is that a bug ?
"Dan Guzman" wrote:
> > The Open Table Query feature on a table (by right clicking on the table)
> > is
> > rather userful for non-technical people as it is visual and one can easily
> > set up some queries without actually key in the SQL code.
> IMHO, Enterprise Manager is somewhere between non-technical and technical.
> The query designer can help someone with cursory database knowledge retrieve
> data but doesn't support some of the more advanced SQL constructs. This is
> why many technical users prefer Query Analyzer.
> Be aware that SQL Server client tools are not really intended to be used for
> end-user ad-hoc reporting. Consider an application like Excel or the Report
> Builder feature of SQL 2005 Reporting Services for end-user ad-hoc queries.
> > (1) save this query so that I can reuse it. (Query Analyzer can do it but
> > then it is not visual)
> Copy/paste the generated SQL and save to a file. To reuse that query, paste
> the SQL into a query designer SQL pane and click the check SQL syntax button
> to refresh the GUI.
> > (2) to output the result as a file in some path.(Again Query Analyzer can
> > do
> > it )
> If you don't want to use QA for this task, you can copy the result grid,
> paste into Excel and save in the format you prefer.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Delf" <Delf@.discussions.microsoft.com> wrote in message
> news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
> > I'm using the Client Tools installation.
> > The Open Table Query feature on a table (by right clicking on the table)
> > is
> > rather userful for non-technical people as it is visual and one can easily
> > set up some queries without actually key in the SQL code.
> >
> > Somehow I just can't find the features that I need :
> >
> > (1) save this query so that I can reuse it. (Query Analyzer can do it but
> > then it is not visual)
> >
> > (2) to output the result as a file in some path.(Again Query Analyzer can
> > do
> > it )
> >
> > Hope someone can share their experience on the above .
> >
>
>|||> When right click on either the SQL or Diagram pane after Open Table Query,
> there is a "Save As" and "Save" but when I click on them, there is no
> response at all. Is that a bug ?
This is documented behavior. From the SQL 2000 Books Online
<Excerpt
href="vdtsql.chm::/_visual_database_tools_usage_considerations.htm">
Although Query Designer provides menu options for saving, these options are
disabled.
</Excerpt>
The chapter also mentions the copy/paste method to print/save results and
queries. I believe the Query Designer tool is intended to be used as a
visual method to create SQL queries and not much else.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Delf" <Delf@.discussions.microsoft.com> wrote in message
news:C480D47F-F225-40CD-8FD3-E5252A1A97FA@.microsoft.com...
> Thanks for the reply. Was expecting it to have a similar save as query and
> a
> way of outputing directly.
> One more question :
> When right click on either the SQL or Diagram pane after Open Table Query,
> there is a "Save As" and "Save" but when I click on them, there is no
> response at all. Is that a bug ?
>
> "Dan Guzman" wrote:
>> > The Open Table Query feature on a table (by right clicking on the
>> > table)
>> > is
>> > rather userful for non-technical people as it is visual and one can
>> > easily
>> > set up some queries without actually key in the SQL code.
>> IMHO, Enterprise Manager is somewhere between non-technical and
>> technical.
>> The query designer can help someone with cursory database knowledge
>> retrieve
>> data but doesn't support some of the more advanced SQL constructs. This
>> is
>> why many technical users prefer Query Analyzer.
>> Be aware that SQL Server client tools are not really intended to be used
>> for
>> end-user ad-hoc reporting. Consider an application like Excel or the
>> Report
>> Builder feature of SQL 2005 Reporting Services for end-user ad-hoc
>> queries.
>> > (1) save this query so that I can reuse it. (Query Analyzer can do it
>> > but
>> > then it is not visual)
>> Copy/paste the generated SQL and save to a file. To reuse that query,
>> paste
>> the SQL into a query designer SQL pane and click the check SQL syntax
>> button
>> to refresh the GUI.
>> > (2) to output the result as a file in some path.(Again Query Analyzer
>> > can
>> > do
>> > it )
>> If you don't want to use QA for this task, you can copy the result grid,
>> paste into Excel and save in the format you prefer.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Delf" <Delf@.discussions.microsoft.com> wrote in message
>> news:72C6A9C1-F843-47C7-A4E6-19F1E8DA7805@.microsoft.com...
>> > I'm using the Client Tools installation.
>> > The Open Table Query feature on a table (by right clicking on the
>> > table)
>> > is
>> > rather userful for non-technical people as it is visual and one can
>> > easily
>> > set up some queries without actually key in the SQL code.
>> >
>> > Somehow I just can't find the features that I need :
>> >
>> > (1) save this query so that I can reuse it. (Query Analyzer can do it
>> > but
>> > then it is not visual)
>> >
>> > (2) to output the result as a file in some path.(Again Query Analyzer
>> > can
>> > do
>> > it )
>> >
>> > Hope someone can share their experience on the above .
>> >
>>sql
Open source tools for performance analysis
Hi all,
Does anyone know of an open source tool capable of analyzing SQL server
performance (something comparable to Spotlight maybe or even something like
OpenSQLTrace with a good interface) ?
Thanks,
kokonut,
I don't know of any Open Source products to do this. SQL Profiler in
combination with Windows Performance monitor is pretty good for this
kind of work.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
kokonut wrote:
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL server
> performance (something comparable to Spotlight maybe or even something like
> OpenSQLTrace with a good interface) ?
> Thanks,
>
|||There is a freeware mode for Quest's Spotlight on SQL Server that's enabled without a key. In the interest of fairness, I think Idera has something similar.
There's also the SQL2H tool that does some tracking of SQL Server perfmon counters. It's one of the top downloads on http://www.microsoft.com/sql.
Hope this helps,
-kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL
> server performance (something comparable to Spotlight maybe or even
> something like OpenSQLTrace with a good interface) ?
> Thanks,
>
Does anyone know of an open source tool capable of analyzing SQL server
performance (something comparable to Spotlight maybe or even something like
OpenSQLTrace with a good interface) ?
Thanks,
kokonut,
I don't know of any Open Source products to do this. SQL Profiler in
combination with Windows Performance monitor is pretty good for this
kind of work.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
kokonut wrote:
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL server
> performance (something comparable to Spotlight maybe or even something like
> OpenSQLTrace with a good interface) ?
> Thanks,
>
|||There is a freeware mode for Quest's Spotlight on SQL Server that's enabled without a key. In the interest of fairness, I think Idera has something similar.
There's also the SQL2H tool that does some tracking of SQL Server perfmon counters. It's one of the top downloads on http://www.microsoft.com/sql.
Hope this helps,
-kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL
> server performance (something comparable to Spotlight maybe or even
> something like OpenSQLTrace with a good interface) ?
> Thanks,
>
Open source tools for performance analysis
Hi all,
Does anyone know of an Open Source tool capable of analyzing SQL server
performance (something comparable to Spotlight maybe or even something like
OpenSQLTrace with a good interface) ?
Thanks,kokonut,
I don't know of any Open Source products to do this. SQL Profiler in
combination with Windows Performance monitor is pretty good for this
kind of work.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
kokonut wrote:
> Hi all,
> Does anyone know of an Open Source tool capable of analyzing SQL server
> performance (something comparable to Spotlight maybe or even something lik
e
> OpenSQLTrace with a good interface) ?
> Thanks,
>|||There is a freeware mode for Quest's Spotlight on SQL Server that's enabled
without a key. In the interest of fairness, I think Idera has something sim
ilar.
There's also the SQL2H tool that does some tracking of SQL Server perfmon counters. It
's one of the top downloads on http://www.microsoft.com/sql.
Hope this helps,
-kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. ([url]www.sqlpass.org[/url
])
> Hi all,
> Does anyone know of an Open Source tool capable of analyzing SQL
> server performance (something comparable to Spotlight maybe or even
> something like OpenSQLTrace with a good interface) ?
> Thanks,
>sql
Does anyone know of an Open Source tool capable of analyzing SQL server
performance (something comparable to Spotlight maybe or even something like
OpenSQLTrace with a good interface) ?
Thanks,kokonut,
I don't know of any Open Source products to do this. SQL Profiler in
combination with Windows Performance monitor is pretty good for this
kind of work.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
kokonut wrote:
> Hi all,
> Does anyone know of an Open Source tool capable of analyzing SQL server
> performance (something comparable to Spotlight maybe or even something lik
e
> OpenSQLTrace with a good interface) ?
> Thanks,
>|||There is a freeware mode for Quest's Spotlight on SQL Server that's enabled
without a key. In the interest of fairness, I think Idera has something sim
ilar.
There's also the SQL2H tool that does some tracking of SQL Server perfmon counters. It
's one of the top downloads on http://www.microsoft.com/sql.
Hope this helps,
-kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. ([url]www.sqlpass.org[/url
])
> Hi all,
> Does anyone know of an Open Source tool capable of analyzing SQL
> server performance (something comparable to Spotlight maybe or even
> something like OpenSQLTrace with a good interface) ?
> Thanks,
>sql
Open source tools for performance analysis
Hi all,
Does anyone know of an open source tool capable of analyzing SQL server
performance (something comparable to Spotlight maybe or even something like
OpenSQLTrace with a good interface) ?
Thanks,kokonut,
I don't know of any Open Source products to do this. SQL Profiler in
combination with Windows Performance monitor is pretty good for this
kind of work.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
kokonut wrote:
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL server
> performance (something comparable to Spotlight maybe or even something like
> OpenSQLTrace with a good interface) ?
> Thanks,
>|||There is a freeware mode for Quest's Spotlight on SQL Server that's enabled without a key. In the interest of fairness, I think Idera has something similar.
There's also the SQL2H tool that does some tracking of SQL Server perfmon counters. It's one of the top downloads on http://www.microsoft.com/sql.
Hope this helps,
-kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL
> server performance (something comparable to Spotlight maybe or even
> something like OpenSQLTrace with a good interface) ?
> Thanks,
>
Does anyone know of an open source tool capable of analyzing SQL server
performance (something comparable to Spotlight maybe or even something like
OpenSQLTrace with a good interface) ?
Thanks,kokonut,
I don't know of any Open Source products to do this. SQL Profiler in
combination with Windows Performance monitor is pretty good for this
kind of work.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
kokonut wrote:
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL server
> performance (something comparable to Spotlight maybe or even something like
> OpenSQLTrace with a good interface) ?
> Thanks,
>|||There is a freeware mode for Quest's Spotlight on SQL Server that's enabled without a key. In the interest of fairness, I think Idera has something similar.
There's also the SQL2H tool that does some tracking of SQL Server perfmon counters. It's one of the top downloads on http://www.microsoft.com/sql.
Hope this helps,
-kev
~~~
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)
> Hi all,
> Does anyone know of an open source tool capable of analyzing SQL
> server performance (something comparable to Spotlight maybe or even
> something like OpenSQLTrace with a good interface) ?
> Thanks,
>
Monday, February 20, 2012
Online Management!
Is there any tools available that allow you to manage sql server online.
Obviously, if a website has an sql server back end it would be convenient to
have some sort of web based gui.
Are these kind of tools available, so i can ask my web host if i can use
something like that.
AJ
I typically build my own; for most of my consulting clients, I want to be
able to manage their database/site, and I want them to be able to manage it
too, but obviously I want us to have a separate tier of functionality. So I
haven't taken the time to investigate tools that likely aren't flexible
enough for my needs. But there are many tools out there that can handle the
basic things like creating/dropping tables, creating procedures, users, etc.
http://www.aspfaq.com/2442
http://www.aspfaq.com/
(Reverse address to reply.)
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>
|||I also haven't had time to play, but I think there is a free download from
MS which is a web based SQL tool...Look around at www.microsoft.com/sql and
see if you can find it... Let us know what you think..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>
Obviously, if a website has an sql server back end it would be convenient to
have some sort of web based gui.
Are these kind of tools available, so i can ask my web host if i can use
something like that.
AJ
I typically build my own; for most of my consulting clients, I want to be
able to manage their database/site, and I want them to be able to manage it
too, but obviously I want us to have a separate tier of functionality. So I
haven't taken the time to investigate tools that likely aren't flexible
enough for my needs. But there are many tools out there that can handle the
basic things like creating/dropping tables, creating procedures, users, etc.
http://www.aspfaq.com/2442
http://www.aspfaq.com/
(Reverse address to reply.)
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>
|||I also haven't had time to play, but I think there is a free download from
MS which is a web based SQL tool...Look around at www.microsoft.com/sql and
see if you can find it... Let us know what you think..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>
Online Management!
Is there any tools available that allow you to manage sql server online.
Obviously, if a website has an sql server back end it would be convenient to
have some sort of web based gui.
Are these kind of tools available, so i can ask my web host if i can use
something like that.
AJI typically build my own; for most of my consulting clients, I want to be
able to manage their database/site, and I want them to be able to manage it
too, but obviously I want us to have a separate tier of functionality. So I
haven't taken the time to investigate tools that likely aren't flexible
enough for my needs. But there are many tools out there that can handle the
basic things like creating/dropping tables, creating procedures, users, etc.
http://www.aspfaq.com/2442
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>|||I also haven't had time to play, but I think there is a free download from
MS which is a web based SQL tool...Look around at www.microsoft.com/sql and
see if you can find it... Let us know what you think..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>
Obviously, if a website has an sql server back end it would be convenient to
have some sort of web based gui.
Are these kind of tools available, so i can ask my web host if i can use
something like that.
AJI typically build my own; for most of my consulting clients, I want to be
able to manage their database/site, and I want them to be able to manage it
too, but obviously I want us to have a separate tier of functionality. So I
haven't taken the time to investigate tools that likely aren't flexible
enough for my needs. But there are many tools out there that can handle the
basic things like creating/dropping tables, creating procedures, users, etc.
http://www.aspfaq.com/2442
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>|||I also haven't had time to play, but I think there is a free download from
MS which is a web based SQL tool...Look around at www.microsoft.com/sql and
see if you can find it... Let us know what you think..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Anthony Judd" <adam.jknight@.optusnet.com.au> wrote in message
news:OAEcdg0qEHA.3760@.TK2MSFTNGP09.phx.gbl...
> Is there any tools available that allow you to manage sql server online.
> Obviously, if a website has an sql server back end it would be convenient
to
> have some sort of web based gui.
> Are these kind of tools available, so i can ask my web host if i can use
> something like that.
> AJ
>
Subscribe to:
Posts (Atom)