Cluster question

Our company are looking at purchasing 2 new servers. One will hold the databases the other will be purely an application server which amongst other things will access the database. If we cluster the two servers and setup sql server active/passive clusteri
ng can we continue to use 2nd node as application server but as failover for sql server?
Yes it is possible, but you would have to have enough resources to run all
the applications. BTW, I think you don't quite understand the
term-active-active. That refers to a specific SQL 7.0 technology that
allowed each nost node to run a separate instance. SQL 2000 either has
single-instance or multi-instance clustering with the host nodes as complete
peers.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bert" <anonymous@.discussions.microsoft.com> wrote in message
news:3C41330A-E708-40F3-B957-5AF11CC5B984@.microsoft.com...
> Our company are looking at purchasing 2 new servers. One will hold the
databases the other will be purely an application server which amongst other
things will access the database. If we cluster the two servers and setup sql
server active/passive clustering can we continue to use 2nd node as
application server but as failover for sql server?

Cluster problems

I was wondering if any of you could offer some help with my cluster. I'm
troubleshooting an existing problem within the company where the website
crashes because the clustered SQL servers' 8x CPUs reach 100%.
I've looked in the event logs of the SQL Servers and the only error is on
one inthe System Log :
User: N/A
Comptuer: SQLCLA
Source: ClusSvc
Categroy: Failover Mgr
Event ID: 1069
Description: Cluster resource "SQL Server (PRODUCTION)' in Resource Group
'PRODUCTION Disk Group' failed.
Any help is gratefully received!
The simple answer is the SQL instance didn't respond to the Cluster Service
LooksAlive and IsAlive tests within the allowed timeout period. The Cluster
interpreted that as a failure and acted appropriately.
The complex answer is to find out why your server is running at CPU
saturation. Until you find the answer to that question, you will still
experience cluster failures. You need to do a performance impacy analysis
of your server to determine the cause of the load. One common cause of this
is complex math or string manipulation code running in the server. Usually
that is better done at the application layer rather than at the data layer.
Unfortunately fixing that generally requires an application change. If that
is off the table, start shopping for a 16-way or higher server.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"savvy95" <savvy95@.discussions.microsoft.com> wrote in message
news:554168C0-0879-45A4-9D43-1079F4E8A6AC@.microsoft.com...
>I was wondering if any of you could offer some help with my cluster. I'm
> troubleshooting an existing problem within the company where the website
> crashes because the clustered SQL servers' 8x CPUs reach 100%.
> I've looked in the event logs of the SQL Servers and the only error is on
> one inthe System Log :
> User: N/A
> Comptuer: SQLCLA
> Source: ClusSvc
> Categroy: Failover Mgr
> Event ID: 1069
> Description: Cluster resource "SQL Server (PRODUCTION)' in Resource Group
> 'PRODUCTION Disk Group' failed.
> Any help is gratefully received!
|||Followup to my previous post.
If this is a Hyper-Thread enabled host, restrict MAXDOP (Maximum Degree of
Parallelism) to the actual physical CPU count or lower. This won't help
query processing but may give the server a chance to respond to the CLuster
checks and keep it from failing over. The really good news is you cna
change this without restarting your server.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Admininistrator
"savvy95" <savvy95@.discussions.microsoft.com> wrote in message
news:554168C0-0879-45A4-9D43-1079F4E8A6AC@.microsoft.com...
>I was wondering if any of you could offer some help with my cluster. I'm
> troubleshooting an existing problem within the company where the website
> crashes because the clustered SQL servers' 8x CPUs reach 100%.
> I've looked in the event logs of the SQL Servers and the only error is on
> one inthe System Log :
> User: N/A
> Comptuer: SQLCLA
> Source: ClusSvc
> Categroy: Failover Mgr
> Event ID: 1069
> Description: Cluster resource "SQL Server (PRODUCTION)' in Resource Group
> 'PRODUCTION Disk Group' failed.
> Any help is gratefully received!

Cluster access using IP

I joined a company as a DBA
the company has cluster servers set up.
I was given the 3 ip addresses. i for the cluster and 2 for for the ones the
cluster is made up of. and my login is set up to use SQL Server
Authentication.
How do i connect to the server. I do not know if they are active/active or
active/passive. I do not have any rights on the local boxes for me to telnet
them.
What is the way to connect to the database
what is the default instance that SQl server creates.
thanks a lots in advance
Connect to the address of the SQL Virtual Server, not just the cluster
address or the address of either machine (node).
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Nik" <patelnikhil30@.hotmail.com> wrote in message
news:%23%230sxSelEHA.3156@.TK2MSFTNGP12.phx.gbl...
>I joined a company as a DBA
> the company has cluster servers set up.
> I was given the 3 ip addresses. i for the cluster and 2 for for the ones
> the
> cluster is made up of. and my login is set up to use SQL Server
> Authentication.
> How do i connect to the server. I do not know if they are active/active or
> active/passive. I do not have any rights on the local boxes for me to
> telnet
> them.
> What is the way to connect to the database
> what is the default instance that SQl server creates.
> thanks a lots in advance
>

Clueless ... SBA and ACCESS

Hello,

Hopefully I'm near the right discussion group.

I'm trying to get started with integrating some of my manufacturing company's ACCESS databases with Microsoft's Small Business Accounting (SBA). The SDK for SBA provides plenty of VB code one I get past a certain point.

Can ACCESS be used as a front end for SBA?

Can anyone offer a sample .mdb with code that logs in to the db and adds a new customer (for example)?

TIA

rick

Definitely not the right group, Rick, as Access/VBA can not directly use ADO.NET. I don't know much about SBA, but I took a quick look, and on my system SBA stores its data in a SQL Server instance called ServerName\MICROSOFTSMLBIZ. You should, as far as I know, be able to connect to it from Access using any of the standard methods commonly used to connect to any SQL Server database, e.g. ADP, ODBC-linked tables, or programmatically via ADO 'classic' or DAO. If you haven't already done so, try asking in a forum dealing with Access ADPs or Access and ODBC. -- Brendan Reynolds Access MVP wrote in message news:6f240fe4-d011-4650-a122-ad993505a198@.discussions.microsoft.com...
> Hello, >
> Hopefully I'm near the right discussion group. >
> I'm trying to get started with integrating some of my manufacturing
> company's ACCESS databases with Microsoft's Small Business Accounting
> (SBA). The SDK for SBA provides plenty of VB code one I get past a
> certain point. >
> Can ACCESS be used as a front end for SBA? >
> Can anyone offer a sample .mdb with code that logs in to the db and adds
> a new customer (for example)? >
> TIA > > >
> rick >
>

Clocking Report

Hi,

I have to report the clocking for our company employees. The main clocking table is just employee number & Date/Time clocked. An employee can have any number of clockings per day.

Would it be possible to create a select statement so that there is just 1 row per day for each employee?

[Table Rows]

piet, 2007-02-23 07:59

piet, 2007-02-23 13:01

piet, 2007-02-23 13:55

piet, 2007-02-23 16:35

[Result for SQL statment]

Piet, 2007-02-23, 07:59, 13:01, 13:55, 16:35

Any help will appreciated.

Thanks

Search for Dynamic Pivot and you will find solutions for problems similiar to your post.