any tool which can tell the load of each database running on a SQL

is there any tool which can tell the load of each database running on a SQL
Server
Please reply asap
Thanks
Pankaj Jain
_________________________________________
Nagarro Software Pvt. Ltd.
3 Type B, Electronics City,
Sector 18, Gurgaon, India - 122015
http://www.nagarro.com
Phone (+ 91) 124 - 5016775, 2455301, 2455302, 2455303
Extn. 205
Fax (+ 91) 124 - 2455304
"This electronic communication and any accompanying document are intended
only for the individual or entity to which it is addressed and may contain
confidential and/or privileged information. If you are not the intended
recipient of this message, be aware that any use, review, dissemination,
distribution, or copying of this message is strictly prohibited. If you have
received this communication in error and/or are not the intended recipient,
please notify the sender and delete it from your system. We do not claim
that this information is complete or accurate and any views expressed in
this message are those of the individual sender."
Check this one: http://www.imceda.com/Coefficient_Description.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Pankaj Jain" <pankaj@.nagarro.com> wrote in message
news:eGVlTWnNFHA.2144@.TK2MSFTNGP09.phx.gbl...
> is there any tool which can tell the load of each database running on a
SQL
> Server
> Please reply asap
> Thanks
> Pankaj Jain
> --
> _________________________________________
> Nagarro Software Pvt. Ltd.
> 3 Type B, Electronics City,
> Sector 18, Gurgaon, India - 122015
> http://www.nagarro.com
> Phone (+ 91) 124 - 5016775, 2455301, 2455302, 2455303
> Extn. 205
> Fax (+ 91) 124 - 2455304
>
> "This electronic communication and any accompanying document are intended
> only for the individual or entity to which it is addressed and may contain
> confidential and/or privileged information. If you are not the intended
> recipient of this message, be aware that any use, review, dissemination,
> distribution, or copying of this message is strictly prohibited. If you
have
> received this communication in error and/or are not the intended
recipient,
> please notify the sender and delete it from your system. We do not claim
> that this information is complete or accurate and any views expressed in
> this message are those of the individual sender."
>
|||Hi
Thanks but i already saw this and i want some thing that gives me load in
percentage for all the database that exist in the SQL Server at that point
Thanks
Pankaj Jain
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:OFUFLuoNFHA.1176@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Check this one: http://www.imceda.com/Coefficient_Description.htm.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Pankaj Jain" <pankaj@.nagarro.com> wrote in message
> news:eGVlTWnNFHA.2144@.TK2MSFTNGP09.phx.gbl...
> SQL
intended[vbcol=seagreen]
contain
> have
> recipient,
>
|||Hi,
Did you mean Load in terms of User connections for each databases, then it
is possible.
Select getdate() as Current_time,DB_NAME(DBID) as DBNAME,COUNT(*) from
Master..sysprocesses
Group BY DB_NAME(DBID)
You can schedule the script to execute using OSQL and save it in a fife.
This will give you the amount of users in each database. If needed you can
schedule this script using SQL Agent to run based on specific interval.
Thanks
Hari
SQL Server MVP
"Pankaj Jain" <pankaj@.nagarro.com> wrote in message
news:uKXIbxoNFHA.2520@.tk2msftngp13.phx.gbl...
> Hi
> Thanks but i already saw this and i want some thing that gives me load in
> percentage for all the database that exist in the SQL Server at that point
> Thanks
> Pankaj Jain
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
> message news:OFUFLuoNFHA.1176@.TK2MSFTNGP12.phx.gbl...
> intended
> contain
>

Any tool to give me some live metrics

Id like a nice front end that I can drop to get the server I want or even
combine multiple perfmon sessions for servers in one look and feel.
I also want to look at event logs, current OS /SQL info.. Current
applications running...etc..
Right now, if i have to go to the logs, i have to go to the manage
properties of My computer.. and connect to the server..
Also open Perfmon and select the server.. or even worse, log on to the
server itself to look at current running processes.. I want to make our job
easier by having this one console that i can just drop down on the server I
want and it gives me most of the live info..Something with a web interface
would also be better..
You could check http://www.imceda.com/Product.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eznApwkBFHA.3616@.TK2MSFTNGP11.phx.gbl...
> Id like a nice front end that I can drop to get the server I want or even
> combine multiple perfmon sessions for servers in one look and feel.
> I also want to look at event logs, current OS /SQL info.. Current
> applications running...etc..
> Right now, if i have to go to the logs, i have to go to the manage
> properties of My computer.. and connect to the server..
> Also open Perfmon and select the server.. or even worse, log on to the
> server itself to look at current running processes.. I want to make our
job
> easier by having this one console that i can just drop down on the server
I
> want and it gives me most of the live info..Something with a web interface
> would also be better..
>
|||Hello Hassan,
Check out http://www.quest.com/Quest_Central_f...agnostics.asp. We have a lot of other SQL Server tools which you can see at http://www.quest.com/Quest_Central_for_SQL_Server.
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> Id like a nice front end that I can drop to get the server I want or
> even combine multiple perfmon sessions for servers in one look and
> feel.
> I also want to look at event logs, current OS /SQL info.. Current
> applications running...etc..
> Right now, if i have to go to the logs, i have to go to the manage
> properties of My computer.. and connect to the server..
> Also open Perfmon and select the server.. or even worse, log on to the
> server itself to look at current running processes.. I want to make
> our job
> easier by having this one console that i can just drop down on the
> server I
> want and it gives me most of the live info..Something with a web
> interface
> would also be better..

Any tool to convert Cognos reports to SSRS?

Hi. We've got hundreds of Cognos reports and catalogs and we'd like to convert them to SSRS reports and models. Is there a tool to do this? We're converting our reporting to SSRS and need help. Thanks.I have not came across any tool to convert Cognos Catalog into SSRS Model.
We have to do it manually.
Although there is a tool from Cognos to convert Impromptu Catalog to Cognos ReportNet Model.

Nikul

Any tool to convert Cognos reports to SSRS?

Hi. We've got hundreds of Cognos reports and catalogs and we'd like to convert them to SSRS reports and models. Is there a tool to do this? We're converting our reporting to SSRS and need help. Thanks.I have not came across any tool to convert Cognos Catalog into SSRS Model.
We have to do it manually.
Although there is a tool from Cognos to convert Impromptu Catalog to Cognos ReportNet Model.

Nikul

any simple tool to monitor the execution time of running sql at the database?

as subject
Use Profiler. See SQL Server Books Online for more information.
Also see:
How to identify SQL Server performance issues, by analyzing Profiler output?
http://vyaskn.tripod.com/analyzing_profiler_output.htm
Automating Server Side Tracing in SQL Server
http://vyaskn.tripod.com/server_side...sql_server.htm
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:ePPmY8wlEHA.536@.TK2MSFTNGP11.phx.gbl...
as subject
|||Profiler?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message news:ePPmY8wlEHA.536@.TK2MSFTNGP11.phx.gbl...
> as subject
>

any simple tool to monitor the execution time of running sql at the database?

as subjectUse Profiler. See SQL Server Books Online for more information.
Also see:
How to identify SQL Server performance issues, by analyzing Profiler output?
http://vyaskn.tripod.com/analyzing_profiler_output.htm
Automating Server Side Tracing in SQL Server
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:ePPmY8wlEHA.536@.TK2MSFTNGP11.phx.gbl...
as subject|||Profiler?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message news:ePPmY8wlEHA.536@.TK2MSFTNGP11.phx.gbl...
> as subject
>

Any reliable tool free?

guys,
I am looking for any Sql monitoring tool more or less reliable and free for
evaluation.
Does anyone knows...
Regards,> I am looking for any Sql monitoring tool more or less reliable and free
> for
> evaluation.
> Does anyone knows...
Profiler comes with SQL Server, so it is for free.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Hey
Assuming you have windows 2k + you can also use the for monitoring IO and
other SQL items with administrative tools.
HTH
"Dejan Sarka" wrote:

> Profiler comes with SQL Server, so it is for free.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>

Any recommendation for a good DBA tool.

Hi All
I looking for a good DBA tool to view the REAL TIME performance of my
databases especially the stored procedures. Anyone with recommendations
please help? Thank you in advance.Hi, Maybe Spotlight from Quest Software
"MittyKom" wrote:

> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>|||I'm currently evaluating Quest Spotlight for SQL Server. I've evaluated a
few different offerings and I like this one the best. Additional
performance tools can be purchased as a suite (Quest Central) or as
indiviual components.
HTH
Jerry
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>|||What you want to get from the performance. I use Profiler to mornitor any
SP or ad hoc query that run more than 1 minues. If I found one, then I will
try to optimize the SQL statement. Why am I doing this? because I am a new
DBA, and most of our database design were done by a consultant firm. And I
found that a lot of SP were done terriblely.
Perayu
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>

Any recommendation for a good DBA tool.

Hi All
I looking for a good DBA tool to view the REAL TIME performance of my
databases especially the stored procedures. Anyone with recommendations
please help? Thank you in advance.
Hi, Maybe Spotlight from Quest Software
"MittyKom" wrote:

> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>
|||I'm currently evaluating Quest Spotlight for SQL Server. I've evaluated a
few different offerings and I like this one the best. Additional
performance tools can be purchased as a suite (Quest Central) or as
indiviual components.
HTH
Jerry
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>
|||What you want to get from the performance. I use Profiler to mornitor any
SP or ad hoc query that run more than 1 minues. If I found one, then I will
try to optimize the SQL statement. Why am I doing this? because I am a new
DBA, and most of our database design were done by a consultant firm. And I
found that a lot of SP were done terriblely.
Perayu
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>

Any recommendation for a good DBA tool.

Hi All
I looking for a good DBA tool to view the REAL TIME performance of my
databases especially the stored procedures. Anyone with recommendations
please help? Thank you in advance.Hi, Maybe Spotlight from Quest Software
"MittyKom" wrote:
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>|||I'm currently evaluating Quest Spotlight for SQL Server. I've evaluated a
few different offerings and I like this one the best. Additional
performance tools can be purchased as a suite (Quest Central) or as
indiviual components.
HTH
Jerry
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>|||What you want to get from the performance. I use Profiler to mornitor any
SP or ad hoc query that run more than 1 minues. If I found one, then I will
try to optimize the SQL statement. Why am I doing this? because I am a new
DBA, and most of our database design were done by a consultant firm. And I
found that a lot of SP were done terriblely.
Perayu
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>

Any Program or Tool that helps in convertion !

Hi,
I need a tool or a program that helps me to convert an MS SQL backup
database file with the ( .bak) extension into ( .sql) , I need that
urgently please.
Many Thanks in advance.
Alabdulelah
Hi,
The tool is called "SQL Server"
Seriously. Restore your database, then script it using Enterprise Manager
or Query Analyzer.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
<alabdulelah@.gmail.com> wrote in message
news:1140018773.153566.38100@.z14g2000cwz.googlegro ups.com...
> Hi,
> I need a tool or a program that helps me to convert an MS SQL backup
> database file with the ( .bak) extension into ( .sql) , I need that
> urgently please.
> Many Thanks in advance.
> Alabdulelah
>

Any Program or Tool that helps in convertion !

Hi,
I need a tool or a program that helps me to convert an MS SQL backup
database file with the ( .bak) extension into ( .sql) , I need that
urgently please.
Many Thanks in advance.
Alabdulelahalabdulelah@.gmail.com wrote:
> Hi,
> I need a tool or a program that helps me to convert an MS SQL backup
> database file with the ( .bak) extension into ( .sql) , I need that
> urgently please.
> Many Thanks in advance.
> Alabdulelah
You can restore a SQL Backup to SQL Server using the RESTORE DATABASE
command. Once you've done that you can script the database schema as a
SQL script using the Generate Script feature of SQL 2000 Enterprise
Manager or SQL 2005 Management Studio. (I assume SQL scripts are what
you mean when you say you want a .SQL file?)
Scripting the data itself may be harder depending on how much and how
complex it is. Two possible solutions:
http://vyaskn.tripod.com/code.htm#inserts
http://www.red-gate.com/products/SQ...mpare/index.htm
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Any other patch need to installed besides SP3a?

Hi,
I installed SP3a for MS SQL 2000. Do I need to install any other tools to prevent from hacking?
e.g. IIS Lockdown Tool for windows 2000 server IIS 5
Thanks for advice
You should check all your servers with these security tools.
http://www.microsoft.com/downloads/d...displaylang=en
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Tom" <kerocow@.yahoo.com> wrote in message
news:EEC32889-130C-4327-8AA2-A1F41BFD1430@.microsoft.com...
> Hi,
> I installed SP3a for MS SQL 2000. Do I need to install any other tools to
prevent from hacking?
> e.g. IIS Lockdown Tool for windows 2000 server IIS 5
> Thanks for advice
|||Tom,
You might want to install the MS03-031 security update.
http://www.microsoft.com/technet/sec.../MS03-031.mspx
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Tom wrote:
> Hi,
> I installed SP3a for MS SQL 2000. Do I need to install any other tools to prevent from hacking?
> e.g. IIS Lockdown Tool for windows 2000 server IIS 5
> Thanks for advice
|||Thanks for help

Any other patch need to installed besides SP3a?

Hi,
I installed SP3a for MS SQL 2000. Do I need to install any other tools to pr
event from hacking?
e.g. IIS Lockdown Tool for Windows 2000 server IIS 5
Thanks for adviceYou should check all your servers with these security tools.
CDE4D933600&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Tom" <kerocow@.yahoo.com> wrote in message
news:EEC32889-130C-4327-8AA2-A1F41BFD1430@.microsoft.com...
> Hi,
> I installed SP3a for MS SQL 2000. Do I need to install any other tools to
prevent from hacking?
> e.g. IIS Lockdown Tool for Windows 2000 server IIS 5
> Thanks for advice|||Tom,
You might want to install the MS03-031 security update.
http://www.microsoft.com/technet/se...n/MS03-031.mspx
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Tom wrote:
> Hi,
> I installed SP3a for MS SQL 2000. Do I need to install any other tools to
prevent from hacking?
> e.g. IIS Lockdown Tool for Windows 2000 server IIS 5
> Thanks for advice|||Thanks for help

Any load testing tool to test queries

Guys,

Is there any tool that can test the scalability of Analysis Services?

Basically we want to fire multiple queries to the Analysis Services and check if there is any performance degradation.

Is there any utility or tool that I can use?

Rgds

Hari

SQL Performance monitor works with SSAS too.|||

The Community samples site has an ASLoadSim tool listed which might be worth a look http://www.codeplex.com/SQLSrvAnalysisSrvcs

any HTML DB like tool on SQL Server/.NET?

Just wondering if there are any tools out like Oracle's HTML DB for
configuring quick apps for MS SQL Server/.NET platform.
I have not use Oracle's tool (and I don't know what it does) but perhaps you
could look into SQL Server Web Data Administrator
http://www.microsoft.com/downloads/d...displaylang=en
Perhaps this will have the functionality that you desire.
Keith
"Peter Yao" <nospam@.nospam.com> wrote in message
news:OsNrunPQFHA.3288@.TK2MSFTNGP14.phx.gbl...
> Just wondering if there are any tools out like Oracle's HTML DB for
> configuring quick apps for MS SQL Server/.NET platform.
>

any good sql client tool to connect database

any good sql client tool to connect database
thx
How about Query Analyzer? What exactly are you looking for?
David Portas
SQL Server MVP
|||Hi
This will depend on what your requirements are! If you are writing your own
front end then all you need to install is MDAC, if you want an
administration tool then you could use the Microsoft Web Data Administrator
or others listed at http://www.aspfaq.com/show.asp?id=2442
John
"inamori" <test@.test.com> wrote in message
news:cnqcvo$l191@.imsp212.netvigator.com...
> any good sql client tool to connect database
>
> thx
>
|||TOAD for SQL Server is nice. Even better if you are working with Oracle as
well as SQL Server.
www.toadsoft.com
I normally just use Query Analyzer however, or Visual Studio.
Rick Sawtell
MCT, MCSD, MCDBA
"inamori" <test@.test.com> wrote in message
news:cnqcvo$l191@.imsp212.netvigator.com...
> any good sql client tool to connect database
>
> thx
>

any good sql client tool to connect database

any good sql client tool to connect database
thxHow about Query Analyzer? What exactly are you looking for?
David Portas
SQL Server MVP
--|||Hi
This will depend on what your requirements are! If you are writing your own
front end then all you need to install is MDAC, if you want an
administration tool then you could use the Microsoft Web Data Administrator
or others listed at http://www.aspfaq.com/show.asp?id=2442
John
"inamori" <test@.test.com> wrote in message
news:cnqcvo$l191@.imsp212.netvigator.com...
> any good sql client tool to connect database
>
> thx
>|||TOAD for SQL Server is nice. Even better if you are working with Oracle as
well as SQL Server.
www.toadsoft.com
I normally just use Query Analyzer however, or Visual Studio.
Rick Sawtell
MCT, MCSD, MCDBA
"inamori" <test@.test.com> wrote in message
news:cnqcvo$l191@.imsp212.netvigator.com...
> any good sql client tool to connect database
>
> thx
>

any good sql client tool to connect database

any good sql client tool to connect database
thxHow about Query Analyzer? What exactly are you looking for?
--
David Portas
SQL Server MVP
--|||Hi
This will depend on what your requirements are! If you are writing your own
front end then all you need to install is MDAC, if you want an
administration tool then you could use the Microsoft Web Data Administrator
or others listed at http://www.aspfaq.com/show.asp?id=2442
John
"inamori" <test@.test.com> wrote in message
news:cnqcvo$l191@.imsp212.netvigator.com...
> any good sql client tool to connect database
>
> thx
>|||TOAD for SQL Server is nice. Even better if you are working with Oracle as
well as SQL Server.
www.toadsoft.com
I normally just use Query Analyzer however, or Visual Studio.
Rick Sawtell
MCT, MCSD, MCDBA
"inamori" <test@.test.com> wrote in message
news:cnqcvo$l191@.imsp212.netvigator.com...
> any good sql client tool to connect database
>
> thx
>

Any good reporting tool?

Hello!
Our company was looking for good reporting tool... and found
It is here: http://www.perpetuumsoft.com
I just want to know: Does anybody use it?
Is it worth to purchase?
Any comments on this product or good alternatives.
Thanks in advance.And what was exactly wrong with SQL RS?
"ChrisSammer" <u41467@.uwe> wrote in message news:804c3d2282f79@.uwe...
> Hello!
> Our company was looking for good reporting tool... and found
> It is here: http://www.perpetuumsoft.com
> I just want to know: Does anybody use it?
> Is it worth to purchase?
> Any comments on this product or good alternatives.
> Thanks in advance.|||This NG is about SQL Server reporting Services, which comes with its own
reporting designer (or "reporting tool" as your term?), no other
tools/alternatives can be used to generate report for SQL Server RS, AFAIK,
so far.
"ChrisSammer" <u41467@.uwe> wrote in message news:804c3d2282f79@.uwe...
> Hello!
> Our company was looking for good reporting tool... and found
> It is here: http://www.perpetuumsoft.com
> I just want to know: Does anybody use it?
> Is it worth to purchase?
> Any comments on this product or good alternatives.
> Thanks in advance.|||Good alternative - http://www.sisense.com
"ChrisSammer" <u41467@.uwe> wrote in message news:804c3d2282f79@.uwe...
> Hello!
> Our company was looking for good reporting tool... and found
> It is here: http://www.perpetuumsoft.com
> I just want to know: Does anybody use it?
> Is it worth to purchase?
> Any comments on this product or good alternatives.
> Thanks in advance.