Showing posts with label performance. Show all posts
Showing posts with label performance. Show all posts

Friday, February 24, 2012

ANN: SQL Monitor Version 2 has just been released

SQL Monitor version 2.0 has just been released.

http://dbmonitor.tripod.com
SQL Monitor is an application that displays performance statistics for
sessions running on SQL Server databases. It has a very small
footprint on the server yet displays all the information required for
a DBA or database developer to see the impact individual sessions have
on a database server.

Features include:

Email alerts for performance issues or unexpected disconnects on
database servers
Logging of performance figures and individual session connects/
disconnects
Multi-server graph display showing all connected servers on the one
screen
Process information broken down into database/ user or session lists
Locking panel to display locking information
Simple one click server login
Adjustable server refresh from 1 second to two minutes
No time limit on trial (Restricted to max of 2 servers concurrently
connected)
Ability to sort the session lists based on activity between sessions

NOTE: This is a total rewrite of the previous version of DBMonitor.
All the excellent features of the previous application have been
incorporated and expanded into the new application.
The link is down.
Other links?|||On May 29, 7:13 pm, Trevize <jbg...@.gmail.comwrote:

Quote:

Originally Posted by

The link is down.
Other links?


Ops. lol.

The download link is now working.

Sunday, February 19, 2012

Analyze Backup Server

I am trying to analyze/identify the bottleneck on our new backup
server. I was wondering if someone could recommend some performance
counters to watch.
Right now I am watching "% Write Time" I am averaging around
"500" for this measure while copying a 50GB database file. It is
taking almost twice as long to copy the file to a different server as
opposed to a different direct attached array. The % disk write counter
is similar on both servers. Am I wrong to assume that the physical
disks are the bottleneck (due to high performance counter ratings)?
Does anyone know some general guide lines on real world throughput on
the following? What kinds of things should I be looking at and/or
asking our IT department?
Gigabit dedicated network
Perc4 (I read on Dells site that it is 320MB/s which translates to
1.1TB / hour)
Raid 5 using 6 - 300MB disks (10,000 RPM)
Other bottleneck candidate?
Server Configuration
Windows Server 2003
Dell PowerEdge 2850
Perc4 - Raid 5
PowerVault 200s
Gigabit networkdaveg.01@.gmail.com wrote:
> I am trying to analyze/identify the bottleneck on our new backup
> server. I was wondering if someone could recommend some performance
> counters to watch.
> Right now I am watching "% Write Time" I am averaging around
> "500" for this measure while copying a 50GB database file. It is
> taking almost twice as long to copy the file to a different server as
> opposed to a different direct attached array. The % disk write counter
> is similar on both servers. Am I wrong to assume that the physical
> disks are the bottleneck (due to high performance counter ratings)?
>
> Does anyone know some general guide lines on real world throughput on
> the following? What kinds of things should I be looking at and/or
> asking our IT department?
> Gigabit dedicated network
> Perc4 (I read on Dells site that it is 320MB/s which translates to
> 1.1TB / hour)
> Raid 5 using 6 - 300MB disks (10,000 RPM)
> Other bottleneck candidate?
>
> Server Configuration
> Windows Server 2003
> Dell PowerEdge 2850
> Perc4 - Raid 5
> PowerVault 200s
> Gigabit network
>
5 of 6 disks at 60MB/sec is 300MB/sec for sustained transfer at
the disk level. You might verify that the disk transfer rate
is full Ultra320. A cabling or termination problem might
reduce the transfer rate.
The PERC4 listed here, has a 64 bit 66MHz interface, and as long
as it is fully utilizing the bus, the bus should not be a limit.
Sometimes a bus segment can be slowed, by the presence of a slower
card. So you may want to check the card configuration and bus
structure of your server.
http://www.jjwei.com/shop/item.asp?itemid=78
But your Gigabit Ethernet only does 125MB/sec theoretical in one
direction, so a single transaction with your server will be limited
by the network. A local transfer on the server itself could go faster.
Plenty of little things to check.
Paul|||Assuming everything is configured properly, how long would I expect it
to take to transfer a 50GB file to the backup server?
If the perfmon coutner "%disk write" goes above 100 should I assume
that the physical disks are the bottleneck?
Paul wrote:
> daveg.01@.gmail.com wrote:
> > I am trying to analyze/identify the bottleneck on our new backup
> > server. I was wondering if someone could recommend some performance
> > counters to watch.
> >
> > Right now I am watching "% Write Time" I am averaging around
> > "500" for this measure while copying a 50GB database file. It is
> > taking almost twice as long to copy the file to a different server as
> > opposed to a different direct attached array. The % disk write counter
> > is similar on both servers. Am I wrong to assume that the physical
> > disks are the bottleneck (due to high performance counter ratings)?
> >
> >
> > Does anyone know some general guide lines on real world throughput on
> > the following? What kinds of things should I be looking at and/or
> > asking our IT department?
> >
> > Gigabit dedicated network
> > Perc4 (I read on Dells site that it is 320MB/s which translates to
> > 1.1TB / hour)
> > Raid 5 using 6 - 300MB disks (10,000 RPM)
> > Other bottleneck candidate?
> >
> >
> > Server Configuration
> > Windows Server 2003
> > Dell PowerEdge 2850
> > Perc4 - Raid 5
> > PowerVault 200s
> > Gigabit network
> >
> 5 of 6 disks at 60MB/sec is 300MB/sec for sustained transfer at
> the disk level. You might verify that the disk transfer rate
> is full Ultra320. A cabling or termination problem might
> reduce the transfer rate.
> The PERC4 listed here, has a 64 bit 66MHz interface, and as long
> as it is fully utilizing the bus, the bus should not be a limit.
> Sometimes a bus segment can be slowed, by the presence of a slower
> card. So you may want to check the card configuration and bus
> structure of your server.
> http://www.jjwei.com/shop/item.asp?itemid=78
> But your Gigabit Ethernet only does 125MB/sec theoretical in one
> direction, so a single transaction with your server will be limited
> by the network. A local transfer on the server itself could go faster.
> Plenty of little things to check.
> Paul|||Dave wrote:
> Assuming everything is configured properly, how long would I expect it
> to take to transfer a 50GB file to the backup server?
> If the perfmon coutner "%disk write" goes above 100 should I assume
> that the physical disks are the bottleneck?
>
> Paul wrote:
> > daveg.01@.gmail.com wrote:
> > > I am trying to analyze/identify the bottleneck on our new backup
> > > server. I was wondering if someone could recommend some performance
> > > counters to watch.
> > >
> > > Right now I am watching "% Write Time" I am averaging around
> > > "500" for this measure while copying a 50GB database file. It is
> > > taking almost twice as long to copy the file to a different server as
> > > opposed to a different direct attached array. The % disk write counter
> > > is similar on both servers. Am I wrong to assume that the physical
> > > disks are the bottleneck (due to high performance counter ratings)?
> > >
> > >
> > > Does anyone know some general guide lines on real world throughput on
> > > the following? What kinds of things should I be looking at and/or
> > > asking our IT department?
> > >
> > > Gigabit dedicated network
> > > Perc4 (I read on Dells site that it is 320MB/s which translates to
> > > 1.1TB / hour)
> > > Raid 5 using 6 - 300MB disks (10,000 RPM)
> > > Other bottleneck candidate?
> > >
> > >
> > > Server Configuration
> > > Windows Server 2003
> > > Dell PowerEdge 2850
> > > Perc4 - Raid 5
> > > PowerVault 200s
> > > Gigabit network
> > >
> >
> > 5 of 6 disks at 60MB/sec is 300MB/sec for sustained transfer at
> > the disk level. You might verify that the disk transfer rate
> > is full Ultra320. A cabling or termination problem might
> > reduce the transfer rate.
> >
> > The PERC4 listed here, has a 64 bit 66MHz interface, and as long
> > as it is fully utilizing the bus, the bus should not be a limit.
> > Sometimes a bus segment can be slowed, by the presence of a slower
> > card. So you may want to check the card configuration and bus
> > structure of your server.
> >
> > http://www.jjwei.com/shop/item.asp?itemid=78
> >
> > But your Gigabit Ethernet only does 125MB/sec theoretical in one
> > direction, so a single transaction with your server will be limited
> > by the network. A local transfer on the server itself could go faster.
> > Plenty of little things to check.
> >
> > Paul|||I am trying to analyze/identify the bottleneck on our new backup
server. I was wondering if someone could recommend some performance
counters to watch.
Right now I am watching "% Write Time" I am averaging around
"500" for this measure while copying a 50GB database file. It is
taking almost twice as long to copy the file to a different server as
opposed to a different direct attached array. The % disk write counter
is similar on both servers. Am I wrong to assume that the physical
disks are the bottleneck (due to high performance counter ratings)?
Does anyone know some general guide lines on real world throughput on
the following? What kinds of things should I be looking at and/or
asking our IT department?
Gigabit dedicated network
Perc4 (I read on Dells site that it is 320MB/s which translates to
1.1TB / hour)
Raid 5 using 6 - 300MB disks (10,000 RPM)
Other bottleneck candidate?
Server Configuration
Windows Server 2003
Dell PowerEdge 2850
Perc4 - Raid 5
PowerVault 200s
Gigabit network|||Dave wrote:
> Assuming everything is configured properly, how long would I expect it
> to take to transfer a 50GB file to the backup server?
> If the perfmon coutner "%disk write" goes above 100 should I assume
> that the physical disks are the bottleneck?
If the transfer is over the network, the limit is 125MB/sec. To transfer
a 50GB file takes 400 seconds.
Paul
> Paul wrote:
>> daveg.01@.gmail.com wrote:
>> I am trying to analyze/identify the bottleneck on our new backup
>> server. I was wondering if someone could recommend some performance
>> counters to watch.
>> Right now I am watching "% Write Time" I am averaging around
>> "500" for this measure while copying a 50GB database file. It is
>> taking almost twice as long to copy the file to a different server as
>> opposed to a different direct attached array. The % disk write counter
>> is similar on both servers. Am I wrong to assume that the physical
>> disks are the bottleneck (due to high performance counter ratings)?
>>
>> Does anyone know some general guide lines on real world throughput on
>> the following? What kinds of things should I be looking at and/or
>> asking our IT department?
>> Gigabit dedicated network
>> Perc4 (I read on Dells site that it is 320MB/s which translates to
>> 1.1TB / hour)
>> Raid 5 using 6 - 300MB disks (10,000 RPM)
>> Other bottleneck candidate?
>>
>> Server Configuration
>> Windows Server 2003
>> Dell PowerEdge 2850
>> Perc4 - Raid 5
>> PowerVault 200s
>> Gigabit network
>> 5 of 6 disks at 60MB/sec is 300MB/sec for sustained transfer at
>> the disk level. You might verify that the disk transfer rate
>> is full Ultra320. A cabling or termination problem might
>> reduce the transfer rate.
>> The PERC4 listed here, has a 64 bit 66MHz interface, and as long
>> as it is fully utilizing the bus, the bus should not be a limit.
>> Sometimes a bus segment can be slowed, by the presence of a slower
>> card. So you may want to check the card configuration and bus
>> structure of your server.
>> http://www.jjwei.com/shop/item.asp?itemid=78
>> But your Gigabit Ethernet only does 125MB/sec theoretical in one
>> direction, so a single transaction with your server will be limited
>> by the network. A local transfer on the server itself could go faster.
>> Plenty of little things to check.
>> Paul
>|||On Sun, 14 Jan 2007 06:54:21 -0500, Paul <nospam@.needed.com>
wrote:
>Dave wrote:
>> Assuming everything is configured properly, how long would I expect it
>> to take to transfer a 50GB file to the backup server?
>> If the perfmon coutner "%disk write" goes above 100 should I assume
>> that the physical disks are the bottleneck?
>If the transfer is over the network, the limit is 125MB/sec. To transfer
>a 50GB file takes 400 seconds.
> Paul
>
I'd be surprised if a real transfer averages over 90MB/s,
especially if TCP/IP

Thursday, February 16, 2012

Analysis Services with Oracle

Does anyone know if using Analysis Services with Oralce via OLEDB adversly affects performance compared to using it with a SQL Server Database?I use Oracle 8.1.7 with Analysis Services. I can't really compare between the performance with SQL Server, but performance is OK with Oracle. We use views as the sources, so those needed to be tuned.
The processing of a cube gives you the exact SQL statement it performs, so you can tune these. These will eat up considerable space in the Oracle temp tablespace, because of the sorts.
Another factor is of course the network speed between the database server and the Analysis Services server.

BTW: Because we encountered 'Data Source errors' we now use (after some hours searching for a solution) the Oracle provided OLE DB provider for defining the cubes and dimensions and the 'Microsoft OLE DB provider for Oracle' for processing those. Don't ask me what the difference exactly is, but this way it works fine for me.

Good luck, Edwin

Monday, February 13, 2012

Analysis Services Performance

We have an Analysis Services server that freezes from time to time (processor is sometimes very high, memory is high, and then we can not even stop the service - as if it went in an infinite loop).

I would like to know whether the following configuration overloads the service or not:

4Gb of RAM

SQL Server and Analysis Services installed on the machine

SQL Server limited to 1Gb of RAM

Analysis Services stay below 1.5Gb

Analysis services takes the rest

We have 102 cubes, some of them up to 100Mb

Apriori, is that configuration overloading the processor, or the problem is somewhere else?

102 cubes does sound a little extreme. I need to ask, are you running 2005 or 2000? Also are you running anything else on the box? SSRS?

B.

Thursday, February 9, 2012

Analysis Services 2005 Performance Guide goes live!

The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site at: http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Edward,

I haven't really gotten a chance to dig into the guide yet, but kudos to the entire team that contributed to it! Just glancing at the TOC, it looks to be an excellent guide and a great read for all of us!!

Dave Fackler

|||Great - now sent directly to the printer :-)|||Wow, thank you guys!|||Reading it now. Thanks!|||

Hi Edward,

This is really exiciting,

This is one thing that was missing from the start.

Regards

Vijay R

|||Having just finished reading the SSAS 2005 Performance Guide in preparation for a large incoming BI project, I consider this guide to be technically indispensable as well as exceptionally readable -- a rare combo! Lastly, it reinforces the sophistication of AS 2005. Well done to the author and subject matter experts!|||

I noticed in the document that it applies to Sql Server 2005 - SP2.

When is SP2 going to be released?

There is a lot of great information in the guide that I am sure applies to SP1 as well, but what in it is SP2 specific?

Thanks,

Wino.

|||

You will see SP2 release pretty soon :)

Meantime you can try to install CTP of SP2 from http://www.microsoft.com/sql/ctp.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||What a wonderful document. I have been craving something like this ever since getting started with Analysis Services. This is better than any book / articles I have read about the "guts" of AS. Thank you so much!

Analysis Services 2005 Performance Guide goes live!

The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site at: http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Edward,

I haven't really gotten a chance to dig into the guide yet, but kudos to the entire team that contributed to it! Just glancing at the TOC, it looks to be an excellent guide and a great read for all of us!!

Dave Fackler

|||Great - now sent directly to the printer :-)|||Wow, thank you guys!|||Reading it now. Thanks!|||

Hi Edward,

This is really exiciting,

This is one thing that was missing from the start.

Regards

Vijay R

|||Having just finished reading the SSAS 2005 Performance Guide in preparation for a large incoming BI project, I consider this guide to be technically indispensable as well as exceptionally readable -- a rare combo! Lastly, it reinforces the sophistication of AS 2005. Well done to the author and subject matter experts!|||

I noticed in the document that it applies to Sql Server 2005 - SP2.

When is SP2 going to be released?

There is a lot of great information in the guide that I am sure applies to SP1 as well, but what in it is SP2 specific?

Thanks,

Wino.

|||

You will see SP2 release pretty soon :)

Meantime you can try to install CTP of SP2 from http://www.microsoft.com/sql/ctp.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||What a wonderful document. I have been craving something like this ever since getting started with Analysis Services. This is better than any book / articles I have read about the "guts" of AS. Thank you so much!

Analysis Services 2005 Performance Guide goes live!

The much anticipated and eagerly awaited Analysis Services 2005 Performance Guide has been released and is available on the Microsoft download site at: http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Edward,

I haven't really gotten a chance to dig into the guide yet, but kudos to the entire team that contributed to it! Just glancing at the TOC, it looks to be an excellent guide and a great read for all of us!!

Dave Fackler

|||Great - now sent directly to the printer :-)|||Wow, thank you guys!|||Reading it now. Thanks!|||

Hi Edward,

This is really exiciting,

This is one thing that was missing from the start.

Regards

Vijay R

|||Having just finished reading the SSAS 2005 Performance Guide in preparation for a large incoming BI project, I consider this guide to be technically indispensable as well as exceptionally readable -- a rare combo! Lastly, it reinforces the sophistication of AS 2005. Well done to the author and subject matter experts!|||

I noticed in the document that it applies to Sql Server 2005 - SP2.

When is SP2 going to be released?

There is a lot of great information in the guide that I am sure applies to SP1 as well, but what in it is SP2 specific?

Thanks,

Wino.

|||

You will see SP2 release pretty soon :)

Meantime you can try to install CTP of SP2 from http://www.microsoft.com/sql/ctp.mspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||What a wonderful document. I have been craving something like this ever since getting started with Analysis Services. This is better than any book / articles I have read about the "guts" of AS. Thank you so much!