Cluster not responding

We have been having a problem where the cluster controller
does not get a response from the SQL Server from the "are
you alive" request ( select @.@.SERVERNAME ). It seems that
the SQL server does not respond within a couple of minutes
and the request times out.
The Cluster controller then closes down the SQL server
thinking it has failed and tries to restart it.
Has anyone got any means to increase the timeout time, or
reason why SQL Server is not responding ( p.s. it does not
seem to be that busy )
When does this happen? Is it intermittent or do you have a pattern?
What type of activities are taking place at that time?
IsAlive happens every 60 sec by default. It can be changed to a higher value by going to the properties of the SQL Server resource. Instead of increasing the time for IsAlive checks, its important to find what is going
on when you see this behavior?
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Not a real pattern but suggestion is that it happens when
the backups are in progress, but not every time.
ie the backups happen every night at 3pm but only once a
month.
What I'd like to do is tell the cluster controller to wait
longer before assuming the database is down.
The application is not cluster aware and a failover
requires that we relog in the overnight batch
applications. But it does mean the service is available
for the online users in the morning.
|||I have seen something like this when an Anti-Virus scanner is running on the
backup target server. It is something to check.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"David" <daldlay@.hotmail.com> wrote in message
news:35e801c4a53c$55a60160$a301280a@.phx.gbl...
> Not a real pattern but suggestion is that it happens when
> the backups are in progress, but not every time.
> ie the backups happen every night at 3pm but only once a
> month.
> What I'd like to do is tell the cluster controller to wait
> longer before assuming the database is down.
> The application is not cluster aware and a failover
> requires that we relog in the overnight batch
> applications. But it does mean the service is available
> for the online users in the morning.
|||"David" <daldlay@.hotmail.com> wrote in message
news:35e801c4a53c$55a60160$a301280a@.phx.gbl...
> Not a real pattern but suggestion is that it happens when
> the backups are in progress, but not every time.
> ie the backups happen every night at 3pm but only once a
> month.
Are backups going over the same wire that the heartbeat is using?

> What I'd like to do is tell the cluster controller to wait
> longer before assuming the database is down.
> The application is not cluster aware and a failover
> requires that we relog in the overnight batch
> applications. But it does mean the service is available
> for the online users in the morning.

CLR test script SELECT returns no row data

Hi,

The test.sql scripts I write to test CLR stored procedures run successfully, but when I want to display the resulting data in the database with a simple "SELECT * from Employee"

I get the result as:
Name Address
- -
No rows affected.
(1 row(s) returned)

But not the actual row is displayed whereas I would expect to see something like:

Name Address
- -
John Doe
No rows affected.
(1 row(s) returned)

I have another database project where doing the same thing displays the row information but there doesn't seem to be a lot different between the two.

Why no results in first case?

Thanks,
Bahadir
You maybe still have the transaction open and uncommitted, thats why you don′t see the actual row.

HTH; Jens SUessmeyer.

http://www.sqlserver2005.de

Client-server simple question

In SQL 2000, if I'm running Query Analyzer on a client machine, and do
something like
Select * Into NewTable from OldTable
the data records don't all come from the server to my client machine and go
back to the server, do they? Doesn't all the data movement actually take
place ON the server?
The only reason I ask is that during this operation, the LAN icon "light"
in the system tray is solidly lit up, while it's not usually that way (it
usually blinks on and off). Maybe that's just status communication to QA,
but the icon is lit completely solid during this operation.
Thanks.
David WalkerThe data should not be zooming back and forth across the LAN.
What is probably being sent is the clock updates to the QA.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in news:OYnpflb#EHA.3368
@.TK2MSFTNGP15.phx.gbl:
> The data should not be zooming back and forth across the LAN.
> What is probably being sent is the clock updates to the QA.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
OK, thanks. That's what I hoped. The "light" being on solid is strange
for clock updates to the QA, but ... thanks.
David Walker

Client SQL Tools

Hi people,
Does anybody know how to instal a Client SQL Tools on a
Windows 2003 Server.
I am trying to install it but when I select " database
components" from setup, nothing happens on the server...
The installation setup disapears!
Thanks in advance.
Rose
We need to review the sqlstp log files for any errors or clues...
Do you have any other instances of SQL Server installed on this machine?
SQL Server Support
Agnes Panosian
|||No, that=B4s a Windows 2003Web Server.=20
We don=B4t have any SQL instance in this server, we just=20
need the client configuration to connect the database=20
server.
Thanks,
Rose
>--Original Message--
>We need to review the sqlstp log files for any errors or=20
clues...
>Do you have any other instances of SQL Server installed=20
on this machine?
>SQL Server Support
>Agnes Panosian
>.
>

Clearing/Unselecting Multi-Value selections made

I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections?

Up to the top...

Come on now, where our options for this?!!!

Microsoft can do better than this.

|||

Ron,

Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an "All" option and account for it in the sql. I know, this is a huge disappointment and I cannot for the life of me understand how anyone with an ounce of sense would find this acceptable. It sucks. There are 5th tier reporting options that perform way better than this. This is one of the most basic reporting functions. First, we had to wait for the multi-select functionality and now they have gone and messed it up.

|||

Yes i understand and i have tried the workaround. It doesn't help with what i want.

What i want to do is be able to 'clear' all the previous selections made so i can make new multivalue selections without having to go down the list and uncheck the previous selections. Is there a way to do this? It wasn't just a select all, it was also an unselect all.

Clearing/Unselecting Multi-Value selections made

I used to use the 'Select All' to clear the previously selected values by checking and unchecking it. However now with 2005 sp1 this is unavailable. Does anyone know of any way to unselect/clear all selections made without manually going down a long list and unselecting the old selections?

Up to the top...

Come on now, where our options for this?!!!

Microsoft can do better than this.

|||

Ron,

Sorry to tell you but they took away the <select all> functionality in SP1. You now need to manually add an "All" option and account for it in the sql. I know, this is a huge disappointment and I cannot for the life of me understand how anyone with an ounce of sense would find this acceptable. It sucks. There are 5th tier reporting options that perform way better than this. This is one of the most basic reporting functions. First, we had to wait for the multi-select functionality and now they have gone and messed it up.

|||

Yes i understand and i have tried the workaround. It doesn't help with what i want.

What i want to do is be able to 'clear' all the previous selections made so i can make new multivalue selections without having to go down the list and uncheck the previous selections. Is there a way to do this? It wasn't just a select all, it was also an unselect all.

clearing reportviewer and reload of dynamic report

I have an application that builds the SQL Select statement and creates the report in ReportViewer. The trouble is this, it will not reset the data that is already loading in the report. I have to close out of the ReportViewer screen and come back in to make new selection options. What am I missing?.

ReportViewer.ProcessingMode = ProcessingMode.Local
Dim rView As LocalReport = ReportViewer.LocalReport
rView.ReportPath = "myReport.rdlc"
Dim ds As DataSet = GetDonorData() '<-- This executes my sql query
Dim dsDonor As New ReportDataSource()
dsDonor.Name = "dsDonor_Data"
dsDonor.Value = ds.Tables("dsDonor")
rView.DataSources.Add(dsDonor)

PrivateFunction GetDonorData()
Dim dsDispAsNew DataSet
Dim sqlDonorDataAsString ="SELECT * from Table Where Class =" & selitem
Using connectionAsNew SqlConnection("Data Source=Server;"persist security info=False;Database=Test")
Dim commandAsNew SqlCommand(sqlDonorData, connection)
Dim DonorAdapterAsNew SqlDataAdapter(command)
DonorAdapter.Fill(dsDisp,"dsDonor")
DonorAdapter.Dispose()
command.Dispose()
Return dsDisp
EndFunction

If anyone is interested, I added:
"rView.DataSources.Clear" just before the add statement.

|||

Thanksklschultz013

For anyone interested this is slightly different and in C#

//RV2 is the report

RV2.ProcessingMode = ProcessingMode.Local;
RV2.LocalReport.ReportPath = "Reporting/ReportBookings.rdlc"; //the physical name of the report
DataSet ds = RunStoredProcSelect(spStr, ParsArray, ParCnt);//function to return a dataset
ReportDataSource rptds = new ReportDataSource();
rptds.Name = "DataSet1_bBookingSelect";//Name of the Datasource in the Report [as in the report designer]
rptds.Value = ds.Tables[0];
RV2.LocalReport.DataSources.Clear();
RV2.LocalReport.DataSources.Add(rptds);
RV2.LocalReport.Refresh();