We have a 3rd party vendor application that runs on IIS and connects to a
back end SQL Cluster. Sometimes a user will try and run a commission report
and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I
will get a error in MOM 2005 that the "Server Performance Thresholds
SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will try
and run it two or three more times taking up more resources.
If I do a fail over to the other SQL server in the cluster the CPU's will
drop down to their normal ranges and everything works fine.
My question is when performing the "failover" that 10 - 15 seconds it takes
to do this what happens to any data that is trying to write to the database?
Is it lost? And can this cause corruption in the database itself?
Thanks!
Failovers don't cause corruption. Rather, any active transactions are
rolled back when the backup node takes over from the primary node.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:DF8080ED-0DF2-42C7-B1DA-4D9375D0B2EA@.microsoft.com...
We have a 3rd party vendor application that runs on IIS and connects to a
back end SQL Cluster. Sometimes a user will try and run a commission report
and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I
will get a error in MOM 2005 that the "Server Performance Thresholds
SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will try
and run it two or three more times taking up more resources.
If I do a fail over to the other SQL server in the cluster the CPU's will
drop down to their normal ranges and everything works fine.
My question is when performing the "failover" that 10 - 15 seconds it takes
to do this what happens to any data that is trying to write to the database?
Is it lost? And can this cause corruption in the database itself?
Thanks!
|||When you mean "rolled back" the transactions are basically held in cache
until the backup server has taken complete control? Is that correct?
One user received the following error during failover in their web session:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your
network documentation. in Microsoft OLE DB Provider for SQL Server
Is this a concern or only the period before the failover is complete?
Thanks!
"Tom Moreau" wrote:
> Failovers don't cause corruption. Rather, any active transactions are
> rolled back when the backup node takes over from the primary node.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:DF8080ED-0DF2-42C7-B1DA-4D9375D0B2EA@.microsoft.com...
> We have a 3rd party vendor application that runs on IIS and connects to a
> back end SQL Cluster. Sometimes a user will try and run a commission report
> and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and I
> will get a error in MOM 2005 that the "Server Performance Thresholds
> SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will try
> and run it two or three more times taking up more resources.
> If I do a fail over to the other SQL server in the cluster the CPU's will
> drop down to their normal ranges and everything works fine.
> My question is when performing the "failover" that 10 - 15 seconds it takes
> to do this what happens to any data that is trying to write to the database?
> Is it lost? And can this cause corruption in the database itself?
> Thanks!
>
>
|||Not exactly. Anything in cache evaporates. Transactions are written to the
transaction log. If a COMMIT record is not written, then when SQL Server
comes up, all of the work done thus far in that transaction is backed out.
This is true whether you are using a cluster or not.
The network errors go away once SQL Server has come back up again. Clean
apps will try to reconnect.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Scopus69" <Scopus69@.nospam.postalias> wrote in message
news:49B44171-B185-463B-833E-E4190AD923A9@.microsoft.com...
When you mean "rolled back" the transactions are basically held in cache
until the backup server has taken complete control? Is that correct?
One user received the following error during failover in their web session:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your
network documentation. in Microsoft OLE DB Provider for SQL Server
Is this a concern or only the period before the failover is complete?
Thanks!
"Tom Moreau" wrote:
> Failovers don't cause corruption. Rather, any active transactions are
> rolled back when the backup node takes over from the primary node.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Scopus69" <Scopus69@.nospam.postalias> wrote in message
> news:DF8080ED-0DF2-42C7-B1DA-4D9375D0B2EA@.microsoft.com...
> We have a 3rd party vendor application that runs on IIS and connects to a
> back end SQL Cluster. Sometimes a user will try and run a commission
> report
> and the SQL server takes a big hit on the CPU's (Dual 2.0 Ghz Xeon's) and
> I
> will get a error in MOM 2005 that the "Server Performance Thresholds
> SQLSERVR Process > 90% CPU for 15 minutes" Of course the end user will
> try
> and run it two or three more times taking up more resources.
> If I do a fail over to the other SQL server in the cluster the CPU's will
> drop down to their normal ranges and everything works fine.
> My question is when performing the "failover" that 10 - 15 seconds it
> takes
> to do this what happens to any data that is trying to write to the
> database?
> Is it lost? And can this cause corruption in the database itself?
> Thanks!
>
>
Showing posts with label 3rd. Show all posts
Showing posts with label 3rd. Show all posts
Thursday, March 22, 2012
Sunday, February 19, 2012
Client side SQL manager tool?
I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
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
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/...A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
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
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/...A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Client side SQL manager tool?
I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.
MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
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
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net.. .
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>
|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
database. Can someone please recommend a good client side tool for XP?
Thanks.
MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
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
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net.. .
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>
|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Client side SQL manager tool?
I host my website with a 3rd party and need something to manage my SQL
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
--
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
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference:)
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
database. Can someone please recommend a good client side tool for XP?
Thanks.MS has a free web-based SQL admin tool you might take a look at...
Duh! Now that I think about it, you can still use SQL Enterprise Manager ,
just register and connect to the IP and port number...
Also ask your hosting company, many provide tools for you.
--
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
"Bob Smith" <noemail@.please.com> wrote in message
news:lDHjd.39122$Om6.2911@.bignews5.bellsouth.net...
> I host my website with a 3rd party and need something to manage my SQL
> database. Can someone please recommend a good client side tool for XP?
> Thanks.
>|||Hi Bob,
Thanks MVP Wayne for his perfect suggestions and here is some links for
your reference:)
Download: SQL Server Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
The SQL Server Web Data Administrator enables you to easily manage your SQL
Server data, wherever you are. Using its built-in features, you can do the
following from Microsoft Internet Explorer or your favorite Web browser:
- Create and edit databases in SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file
system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Bob,
I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Subscribe to:
Posts (Atom)