How to remove (uninstall ) cluster sql server manually

HI All,
As HIten said,(in my previous post) I am able to remove all the registry
entries except hklm\software\microsoft\mssqlserver after couple of reboots of
the both the nodes.
I am still getting Getting "Cannot delet MSsqlserver: Error while deleting
key" error.
I did not delete any resources in cluadmin. Do i need to delete
sqlserver,agent, search resources only or disk resources also need to get
deleted?
Thanks in advance
Suchi
To be clear enough, In below Kb article it is mentioned as
If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.
I am new to Clusters, what are all the resourcs do i need to delete?
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us
"Suchi" wrote:

> HI All,
>
> As HIten said,(in my previous post) I am able to remove all the registry
> entries except hklm\software\microsoft\mssqlserver after couple of reboots of
> the both the nodes.
> I am still getting Getting "Cannot delet MSsqlserver: Error while deleting
> key" error.
> I did not delete any resources in cluadmin. Do i need to delete
> sqlserver,agent, search resources only or disk resources also need to get
> deleted?
> Thanks in advance
> Suchi
>
>
|||You'll need to go into ClusterAdmin and remove the resources. Don't remove
the disk resource.
Also, check out www.clusterhelp.com for suitable training in clusters.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.com...
To be clear enough, In below Kb article it is mentioned as
If the instance of SQL Server you are removing was clustered, remove any
cluster resources for the instance that may remain in the Cluster
Administrator.
I am new to Clusters, what are all the resourcs do i need to delete?
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us
"Suchi" wrote:

> HI All,
>
> As HIten said,(in my previous post) I am able to remove all the registry
> entries except hklm\software\microsoft\mssqlserver after couple of reboots
> of
> the both the nodes.
> I am still getting Getting "Cannot delet MSsqlserver: Error while
> deleting
> key" error.
> I did not delete any resources in cluadmin. Do i need to delete
> sqlserver,agent, search resources only or disk resources also need to get
> deleted?
> Thanks in advance
> Suchi
>
>
|||Thanks Much tom..
Do i need to delete sql group also to clean the sql server?
"Tom Moreau" wrote:

> You'll need to go into ClusterAdmin and remove the resources. Don't remove
> the disk resource.
> Also, check out www.clusterhelp.com for suitable training in clusters.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.com...
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:
>
>
|||No, just keep the group and the disk resource. Remove everything else
within the SQL group. You'll probably want to reboot afterwards (both
nodes).
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
Thanks Much tom..
Do i need to delete sql group also to clean the sql server?
"Tom Moreau" wrote:

> You'll need to go into ClusterAdmin and remove the resources. Don't remove
> the disk resource.
> Also, check out www.clusterhelp.com for suitable training in clusters.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:DDE03400-B723-4800-BD98-B0891596660A@.microsoft.com...
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual
> instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:
>
>
|||Thanks much Tom.
I have deleted cluster resources (except disk)as you said.
I could delete all except hklm\software\microsoft\mssqlserver on node1.
Node2 is completed cleaned. Eeven deleted
hklm\software\microsoft\mssqlserver from node2.
Still getting cannt delete key while deleting above reg key on node1.
Is there anythng I am missing here?Done several reboots also..
Thanks a lot..
"Tom Moreau" wrote:

> No, just keep the group and the disk resource. Remove everything else
> within the SQL group. You'll probably want to reboot afterwards (both
> nodes).
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
> Thanks Much tom..
> Do i need to delete sql group also to clean the sql server?
>
> "Tom Moreau" wrote:
>
>
|||Hmm. Have you removed all of the binaries, e.g. C:\Program Files\Microsoft
SQL Server\...
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:4F2A3078-2465-421E-BF4C-8D86978E442E@.microsoft.com...
Thanks much Tom.
I have deleted cluster resources (except disk)as you said.
I could delete all except hklm\software\microsoft\mssqlserver on node1.
Node2 is completed cleaned. Eeven deleted
hklm\software\microsoft\mssqlserver from node2.
Still getting cannt delete key while deleting above reg key on node1.
Is there anythng I am missing here?Done several reboots also..
Thanks a lot..
"Tom Moreau" wrote:

> No, just keep the group and the disk resource. Remove everything else
> within the SQL group. You'll probably want to reboot afterwards (both
> nodes).
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Suchi" <Suchi@.discussions.microsoft.com> wrote in message
> news:7611F8B8-0FE7-4B7A-AA1B-DCC928F7DFA0@.microsoft.com...
> Thanks Much tom..
> Do i need to delete sql group also to clean the sql server?
>
> "Tom Moreau" wrote:
>
>
|||Yes Tom. I deleted all binaries.
"Suchi" wrote:
[vbcol=seagreen]
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:
|||And the appropriate keys were removed from CurrentControlSet\Services etc.?
If so, then you may very well have to rebuild the node.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Suchi" <Suchi@.discussions.microsoft.com> wrote in message
news:9D35C0B0-7488-4747-B56B-E787062E5C39@.microsoft.com...
Yes Tom. I deleted all binaries.
"Suchi" wrote:
[vbcol=seagreen]
> To be clear enough, In below Kb article it is mentioned as
> If the instance of SQL Server you are removing was clustered, remove any
> cluster resources for the instance that may remain in the Cluster
> Administrator.
> I am new to Clusters, what are all the resourcs do i need to delete?
> How to manually remove SQL Server 2000 default, named, or virtual
> instance
> http://support.microsoft.com/kb/290991/en-us
>
>
> "Suchi" wrote:

How to refer to report textbox values in another textbox

I want to add up the values in a couple of text boxes in another textbox. How do I refer to the textboxes?

fields!textbox1.value doesn't work..what does?

Hello,

Try this:

ReportItems!textbox1.Value

Hope this helps.

Jarret

How to reduce timeouts in SQL Server?

Hi,
We have designed a system which processes millions of transactions a
year. There are a couple of tables in the system which are heavily
used. These 2 tables gets about 30,000 rows inserted into them
everyday at an average. The inserts are done through stored procedures
after perfomring some complex logic. There are also a few scheduled
jobs that run every night which accesses these 2 tables. In addition,
there are a few reports that run in the web system which acces these
table for ad-hoc reporting. In the last few months, the number of
transactions have increased quite a bit and system started giving us
problems such as a lot of timeouts and a few deadlockks everyday.
I am thinking that if I can somehow replicate these tables every 6
hours or so and then use the new tables for all reporting purposes, my
timeouts might decrease. Could you suggest on how I could go about
replicating these 2 tables in an efficient way? and whether this would
help my situation?
Any other suggestions on how I could improve my system would be
appreciated.
Thanks,
Karanouch....
tough question without being able to see your database.
here are some thoughts...
1. Make sure indexes are being optimized\maintained on a regular basis (Read
up on showContig and on dbcc IndexDefrag)
2. review your critical transactions and make sure that you are not causing
excessive blocking and deadlocks (This is really hard, you'll have to read
up on troubleshooting deadlocks)
3. yes your adhoc reporting should be moved out to another database. You can
use DTS for this, replication or log shipping. We are using log shipping to
satisfy this need.
you're likely going to need to spend some serious hours pinpointing the
problem here. My guess is that option #1 above will buy you some serious
performance gains.
Cheers,
Greg Jackson
PDX, Oregon|||Articles for reference:
http://www.microsoft.com/technet/community/chats/trans/sql/sql1023.mspx
http://vyaskn.tripod.com/watch_your_timeouts.htm
"Karan" wrote:
> Hi,
> We have designed a system which processes millions of transactions a
> year. There are a couple of tables in the system which are heavily
> used. These 2 tables gets about 30,000 rows inserted into them
> everyday at an average. The inserts are done through stored procedures
> after perfomring some complex logic. There are also a few scheduled
> jobs that run every night which accesses these 2 tables. In addition,
> there are a few reports that run in the web system which acces these
> table for ad-hoc reporting. In the last few months, the number of
> transactions have increased quite a bit and system started giving us
> problems such as a lot of timeouts and a few deadlockks everyday.
> I am thinking that if I can somehow replicate these tables every 6
> hours or so and then use the new tables for all reporting purposes, my
> timeouts might decrease. Could you suggest on how I could go about
> replicating these 2 tables in an efficient way? and whether this would
> help my situation?
> Any other suggestions on how I could improve my system would be
> appreciated.
> Thanks,
> Karan
>|||I performed the DBCC SHOWCONTIG on the tables affected and the stats
look ok to me. I am pasting the stats below..
DBCC SHOWCONTIG scanning 'claims' table...
Table: 'table_name' (322100188); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned........................: 202265
- Extents Scanned.......................: 25349
- Extent Switches.......................: 27598
- Avg. Pages per Extent..................: 8.0
- Scan Density [Best Count:Actual Count]......: 91.61% [25284:27599]
- Logical Scan Fragmentation ..............: 0.64%
- Extent Scan Fragmentation ...............: 10.38%
- Avg. Bytes Free per Page................: 672.6
- Avg. Page Density (full)................: 91.69%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Please let me know if you see anything I could improve with this
stats. All other indexes on these table have similar stats as well.
Thanks for your help.
Karan|||looks good to me.
Red Flag would be scan density LESS THAN 80%....You look fine in that
regard.
Greg Jackson
PDX, Oregonsql

How to reduce timeouts in SQL Server?

Hi,
We have designed a system which processes millions of transactions a
year. There are a couple of tables in the system which are heavily
used. These 2 tables gets about 30,000 rows inserted into them
everyday at an average. The inserts are done through stored procedures
after perfomring some complex logic. There are also a few scheduled
jobs that run every night which accesses these 2 tables. In addition,
there are a few reports that run in the web system which acces these
table for ad-hoc reporting. In the last few months, the number of
transactions have increased quite a bit and system started giving us
problems such as a lot of timeouts and a few deadlockks everyday.
I am thinking that if I can somehow replicate these tables every 6
hours or so and then use the new tables for all reporting purposes, my
timeouts might decrease. Could you suggest on how I could go about
replicating these 2 tables in an efficient way? and whether this would
help my situation?
Any other suggestions on how I could improve my system would be
appreciated.
Thanks,
Karan
ouch....
tough question without being able to see your database.
here are some thoughts...
1. Make sure indexes are being optimized\maintained on a regular basis (Read
up on showContig and on dbcc IndexDefrag)
2. review your critical transactions and make sure that you are not causing
excessive blocking and deadlocks (This is really hard, you'll have to read
up on troubleshooting deadlocks)
3. yes your adhoc reporting should be moved out to another database. You can
use DTS for this, replication or log shipping. We are using log shipping to
satisfy this need.
you're likely going to need to spend some serious hours pinpointing the
problem here. My guess is that option #1 above will buy you some serious
performance gains.
Cheers,
Greg Jackson
PDX, Oregon
|||Articles for reference:
http://www.microsoft.com/technet/com...l/sql1023.mspx
http://vyaskn.tripod.com/watch_your_timeouts.htm
"Karan" wrote:

> Hi,
> We have designed a system which processes millions of transactions a
> year. There are a couple of tables in the system which are heavily
> used. These 2 tables gets about 30,000 rows inserted into them
> everyday at an average. The inserts are done through stored procedures
> after perfomring some complex logic. There are also a few scheduled
> jobs that run every night which accesses these 2 tables. In addition,
> there are a few reports that run in the web system which acces these
> table for ad-hoc reporting. In the last few months, the number of
> transactions have increased quite a bit and system started giving us
> problems such as a lot of timeouts and a few deadlockks everyday.
> I am thinking that if I can somehow replicate these tables every 6
> hours or so and then use the new tables for all reporting purposes, my
> timeouts might decrease. Could you suggest on how I could go about
> replicating these 2 tables in an efficient way? and whether this would
> help my situation?
> Any other suggestions on how I could improve my system would be
> appreciated.
> Thanks,
> Karan
>
|||I performed the DBCC SHOWCONTIG on the tables affected and the stats
look ok to me. I am pasting the stats below..
DBCC SHOWCONTIG scanning 'claims' table...
Table: 'table_name' (322100188); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned........................: 202265
- Extents Scanned.......................: 25349
- Extent Switches.......................: 27598
- Avg. Pages per Extent..................: 8.0
- Scan Density [Best Count:Actual Count]......: 91.61% [25284:27599]
- Logical Scan Fragmentation ..............: 0.64%
- Extent Scan Fragmentation ...............: 10.38%
- Avg. Bytes Free per Page................: 672.6
- Avg. Page Density (full)................: 91.69%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Please let me know if you see anything I could improve with this
stats. All other indexes on these table have similar stats as well.
Thanks for your help.
Karan
|||looks good to me.
Red Flag would be scan density LESS THAN 80%....You look fine in that
regard.
Greg Jackson
PDX, Oregon

How to reduce timeouts in SQL Server?

Hi,
We have designed a system which processes millions of transactions a
year. There are a couple of tables in the system which are heavily
used. These 2 tables gets about 30,000 rows inserted into them
everyday at an average. The inserts are done through stored procedures
after perfomring some complex logic. There are also a few scheduled
jobs that run every night which accesses these 2 tables. In addition,
there are a few reports that run in the web system which acces these
table for ad-hoc reporting. In the last few months, the number of
transactions have increased quite a bit and system started giving us
problems such as a lot of timeouts and a few deadlockks everyday.
I am thinking that if I can somehow replicate these tables every 6
hours or so and then use the new tables for all reporting purposes, my
timeouts might decrease. Could you suggest on how I could go about
replicating these 2 tables in an efficient way? and whether this would
help my situation?
Any other suggestions on how I could improve my system would be
appreciated.
Thanks,
Karanouch....
tough question without being able to see your database.
here are some thoughts...
1. Make sure indexes are being optimized\maintained on a regular basis (Read
up on showContig and on dbcc IndexDefrag)
2. review your critical transactions and make sure that you are not causing
excessive blocking and deadlocks (This is really hard, you'll have to read
up on troubleshooting deadlocks)
3. yes your adhoc reporting should be moved out to another database. You can
use DTS for this, replication or log shipping. We are using log shipping to
satisfy this need.
you're likely going to need to spend some serious hours pinpointing the
problem here. My guess is that option #1 above will buy you some serious
performance gains.
Cheers,
Greg Jackson
PDX, Oregon|||Articles for reference:
http://www.microsoft.com/technet/co...ql/sql1023.mspx
http://vyaskn.tripod.com/watch_your_timeouts.htm
"Karan" wrote:

> Hi,
> We have designed a system which processes millions of transactions a
> year. There are a couple of tables in the system which are heavily
> used. These 2 tables gets about 30,000 rows inserted into them
> everyday at an average. The inserts are done through stored procedures
> after perfomring some complex logic. There are also a few scheduled
> jobs that run every night which accesses these 2 tables. In addition,
> there are a few reports that run in the web system which acces these
> table for ad-hoc reporting. In the last few months, the number of
> transactions have increased quite a bit and system started giving us
> problems such as a lot of timeouts and a few deadlockks everyday.
> I am thinking that if I can somehow replicate these tables every 6
> hours or so and then use the new tables for all reporting purposes, my
> timeouts might decrease. Could you suggest on how I could go about
> replicating these 2 tables in an efficient way? and whether this would
> help my situation?
> Any other suggestions on how I could improve my system would be
> appreciated.
> Thanks,
> Karan
>|||I performed the DBCC SHOWCONTIG on the tables affected and the stats
look ok to me. I am pasting the stats below..
DBCC SHOWCONTIG scanning 'claims' table...
Table: 'table_name' (322100188); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned........................: 202265
- Extents Scanned.......................: 25349
- Extent Switches.......................: 27598
- Avg. Pages per Extent..................: 8.0
- Scan Density [Best Count:Actual Count]......: 91.61% [25284:27599
]
- Logical Scan Fragmentation ..............: 0.64%
- Extent Scan Fragmentation ...............: 10.38%
- Avg. Bytes Free per Page................: 672.6
- Avg. Page Density (full)................: 91.69%
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Please let me know if you see anything I could improve with this
stats. All other indexes on these table have similar stats as well.
Thanks for your help.
Karan|||looks good to me.
Red Flag would be scan density LESS THAN 80%....You look fine in that
regard.
Greg Jackson
PDX, Oregon