Performance Counters Missing

After installing Sharepoint application on to my SQL Server 2000, all the
performance counters for SQL went missing.
How do I get them back and would I need to restart SQL/Reboot afterwards?
In NT machine heard about executing,
diskperf -y in command prompt and reboot to get few performance counter
enabled...
Thanks,
Sree
"Woo" wrote:

> After installing Sharepoint application on to my SQL Server 2000, all the
> performance counters for SQL went missing.
> How do I get them back and would I need to restart SQL/Reboot afterwards?
>
|||The server is Windows 2003.
"Sreejith G" wrote:
[vbcol=seagreen]
> In NT machine heard about executing,
> diskperf -y in command prompt and reboot to get few performance counter
> enabled...
> Thanks,
> Sree
> "Woo" wrote:

Performance Counters Missing

After installing Sharepoint application on to my SQL Server 2000, all the
performance counters for SQL went missing.
How do I get them back and would I need to restart SQL/Reboot afterwards?In NT machine heard about executing,
diskperf -y in command prompt and reboot to get few performance counter
enabled...
Thanks,
Sree
"Woo" wrote:
> After installing Sharepoint application on to my SQL Server 2000, all the
> performance counters for SQL went missing.
> How do I get them back and would I need to restart SQL/Reboot afterwards?
>|||The server is Windows 2003.
"Sreejith G" wrote:
> In NT machine heard about executing,
> diskperf -y in command prompt and reboot to get few performance counter
> enabled...
> Thanks,
> Sree
> "Woo" wrote:
> > After installing Sharepoint application on to my SQL Server 2000, all the
> > performance counters for SQL went missing.
> >
> > How do I get them back and would I need to restart SQL/Reboot afterwards?
> >
> >

Performance

Hi...I have a server that responds to web pages
and back end processing...im not sure the best place to start to increase
performance....
im a programmer..not a super dba but im pretty good...
i have two servers at the isp site...was
thinking of putting all the backen store procedures on one server and when
there invoked to retrieve the record sets from server1 ...
looking for some ideas...on how to make this server performance
increase....

thanks
MarkMark wrote:

Quote:

Originally Posted by

Hi...I have a server that responds to web pages
and back end processing...im not sure the best place to start to increase
performance....
im a programmer..not a super dba but im pretty good...
i have two servers at the isp site...was
thinking of putting all the backen store procedures on one server and when
there invoked to retrieve the record sets from server1 ...

You want to minimize the amount of data that has to travel over the
network connection between the servers. I'd put all the SQL stuff
(tables and stored procedures) on one server, all the web front-end
stuff (HTML/ASP/PHP/whatever and images) on the other.

Quote:

Originally Posted by

looking for some ideas...on how to make this server performance
increase....

Memory is faster than disk is faster than network, so:

1) Maximize RAM. There's some slightly non-trivial configuration
involved in getting SQL Server to use more than 2 GB. But don't
let it use quite /all/ the RAM, you need to leave some for the OS.

2) Optimize disk usage. Ideally, keep data, temp, logs, and other
stuff (including the OS) separate. Someone more familiar with
the different types of RAID can chime in here.

3) Minimize network traffic. Filter data server-side, unless the
ugliness of the resulting code outweighs the speed gain.|||"Mark" <analizer1@.yahoo.comwrote in message
news:TI_Ah.14917$O02.4071@.newssvr11.news.prodigy.n et...

Quote:

Originally Posted by

Hi...I have a server that responds to web pages
and back end processing...im not sure the best place to start to increase
performance....
im a programmer..not a super dba but im pretty good...
i have two servers at the isp site...was
thinking of putting all the backen store procedures on one server and when
there invoked to retrieve the record sets from server1 ...
looking for some ideas...on how to make this server performance
increase....

Find the bottleneck.

There's some good books and articles out there on performance tuning. But
figure out if you have lots of disk I/O, CPU or what.

Are your tables properly indexed for example? If not, that's a good place
to look for example.

Quote:

Originally Posted by

>
thanks
Mark
>

|||Mark (analizer1@.yahoo.com) writes:

Quote:

Originally Posted by

Hi...I have a server that responds to web pages
and back end processing...im not sure the best place to start to increase
performance....
im a programmer..not a super dba but im pretty good...
i have two servers at the isp site...was
thinking of putting all the backen store procedures on one server and when
there invoked to retrieve the record sets from server1 ...
looking for some ideas...on how to make this server performance
increase....

Have stored procedures on one server and data on another? Really bad
idea from all points of view. More network traffic, and more risk
for things not working at all.

But if you have web server and SQL Server on the same box, it would be a
good idea to separate them.

If you have multiple databases for multiple clients, it could also be
an idea to scale out. Use Profiler to see which databses that get the
most traffic.

--
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

Perfomance tuning

Dear friends
We have one problem in our existing system.We are expecting some expert comment on this.We have one corebanking system back end as MS SQL server with IIS server.Our system is always very slow in the peak times of tranasactions.We are planning to optimize this with a short time plan .So pls give some suggestions that our DBA team can implement in a short time with SQL SERVER 2000

Thanks in Advance
Filson

A possible course of action is this:

Try to check your IIS's and SQL's processor during the peak times to see if the problem is with your SQL or IIS

If your problem is not in IIS:

Try to see if your sql server's processor is 100% or near. If it is, then your queries are probably too heavy - if it is not, then you possibly have locking problems.

Try to find if there are specific queries that are taking longer. You could use Sql Profiler for this, by specifying a duration minimum threshold for the events - for instance, only show queries that take more than 5 seconds (warning: this might deterioate even further your performance while the trace is active). After finding out the worse queries, try to understand why they are running slow - you could use SQL Query Analyzer for this, using the SP's execution plans.