Rendering report: enterprise

Monday, March 26, 2012

Replacement for Enterprise Manager?

Hello,
I am just wondering if there is a replacement for EM which will have certain
improvements over MS's.
I am coming from an Oracle world, and there is a major issue in SSEM which i
find seriously lacking compared OEM.
In OEM, when you expand a schema (roughly equivalent to a database in SS)
there are a lot more treenodes. There are the basic ones like SSEM has...
Tables, Views, SProcs, Funcs etc...
However OEM also has seperate nodes for Indexes and Triggers, so you can see
and manage all the triggers and indexes in one place. It allows to do all
the relevant management stuff right there. Enable/Disable triggers, Rebuild
indexes, and such. This is a Major improvement, to be able to work directly
on these objects rather then going to a table, designing it, then getting
into the triggers window, selecting the one you want, and then being able to
manage it.
Is there a SSEM alternative which give you more direct and finely-grained
control over individual objects in a similar fashion?
Thanks in advance,
- Hitchhiker
Hi,

> I am just wondering if there is a replacement for EM which will have
certain
> improvements over MS's.
> I am coming from an Oracle world, and there is a major issue in SSEM which
i
> find seriously lacking compared OEM.
> In OEM, when you expand a schema (roughly equivalent to a database in SS)
> there are a lot more treenodes. There are the basic ones like SSEM has...
> Tables, Views, SProcs, Funcs etc...
> However OEM also has seperate nodes for Indexes and Triggers, so you can
see
> and manage all the triggers and indexes in one place. It allows to do all
> the relevant management stuff right there. Enable/Disable triggers,
Rebuild
> indexes, and such. This is a Major improvement, to be able to work
directly
> on these objects rather then going to a table, designing it, then getting
> into the triggers window, selecting the one you want, and then being able
to
> manage it.
> Is there a SSEM alternative which give you more direct and finely-grained
> control over individual objects in a similar fashion?
You might want to download a trial version of Database Workbench:
www.upscene.com
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
|||You might try SQLExecMS from www.laplas-soft.com
"A Traveler" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:OskK3qzmEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am just wondering if there is a replacement for EM which will have
certain
> improvements over MS's.
> I am coming from an Oracle world, and there is a major issue in SSEM which
i
> find seriously lacking compared OEM.
> In OEM, when you expand a schema (roughly equivalent to a database in SS)
> there are a lot more treenodes. There are the basic ones like SSEM has...
> Tables, Views, SProcs, Funcs etc...
> However OEM also has seperate nodes for Indexes and Triggers, so you can
see
> and manage all the triggers and indexes in one place. It allows to do all
> the relevant management stuff right there. Enable/Disable triggers,
Rebuild
> indexes, and such. This is a Major improvement, to be able to work
directly
> on these objects rather then going to a table, designing it, then getting
> into the triggers window, selecting the one you want, and then being able
to
> manage it.
> Is there a SSEM alternative which give you more direct and finely-grained
> control over individual objects in a similar fashion?
> Thanks in advance,
> - Hitchhiker
>
|||This one looks Really Good!. I will have to download it and give it a shot.
Thanks A Lot!!
CheerZ -
"John Smith" <wp456@.mail.ru> wrote in message
news:uw7Vo%234mEHA.2372@.TK2MSFTNGP10.phx.gbl...
> You might try SQLExecMS from www.laplas-soft.com
>
> "A Traveler" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:OskK3qzmEHA.1356@.TK2MSFTNGP09.phx.gbl...
> certain
> i
> see
> Rebuild
> directly
> to
>
|||If you're an Oracle person, you probably know TOAD pretty well. There's a
freeware version for SQL Server at www.toadss.com. You can also download a
freeware copy of Quest Central for SQL Server at
www.quest.com/quest_central/sql_server/freeware.
"A Traveler" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:OskK3qzmEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am just wondering if there is a replacement for EM which will have
certain
> improvements over MS's.
> I am coming from an Oracle world, and there is a major issue in SSEM which
i
> find seriously lacking compared OEM.
> In OEM, when you expand a schema (roughly equivalent to a database in SS)
> there are a lot more treenodes. There are the basic ones like SSEM has...
> Tables, Views, SProcs, Funcs etc...
> However OEM also has seperate nodes for Indexes and Triggers, so you can
see
> and manage all the triggers and indexes in one place. It allows to do all
> the relevant management stuff right there. Enable/Disable triggers,
Rebuild
> indexes, and such. This is a Major improvement, to be able to work
directly
> on these objects rather then going to a table, designing it, then getting
> into the triggers window, selecting the one you want, and then being able
to
> manage it.
> Is there a SSEM alternative which give you more direct and finely-grained
> control over individual objects in a similar fashion?
> Thanks in advance,
> - Hitchhiker
>
|||I just installed Quest Central for SQL Server, and it is slower than
Enterprise Manager...
SQLExecMS is really fast, but it is $100+ for an individual license.
"Kevin Kline" <kevin.kline@.quest.com> wrote in message
news:eCg11eRoEHA.1160@.tk2msftngp13.phx.gbl...
> freeware version for SQL Server at www.toadss.com. You can also download
a
> freeware copy of Quest Central for SQL Server at
> www.quest.com/quest_central/sql_server/freeware.
>
|||Hmmm... It was slower to load the SEM in our testing, but it's operations
were the same or faster. I'll have to talk to our testers to see if we can
reproduce the problem. Thanks for the input.
-Kevin
SQL Server MVP
I support PASS, the Professional Association for SQL Server.
www.sqlpass.org
"Developer" <wanderer@.mapinfo.nope.com> wrote in message
news:%23K07jSupEHA.1152@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I just installed Quest Central for SQL Server, and it is slower than
> Enterprise Manager...
> SQLExecMS is really fast, but it is $100+ for an individual license.
> "Kevin Kline" <kevin.kline@.quest.com> wrote in message
> news:eCg11eRoEHA.1160@.tk2msftngp13.phx.gbl...
download
> a
>
sql

Wednesday, March 21, 2012

Replace Cluster Disks

Hello,

I have a two node SQL 2000 cluster running on windows 2003 enterprise server. We need to replace the SAN disks. Can we not disable SQL service & Cluster service, copy the contents from existing disks to target disks, swap the drive letter & start the services?

What is the best practice to do this? Appreciate your help.

Thanks
Rajan

That 'should' work just fine. But STOP the SQL services, including SQL Agent and SQL Browser that depend upon the drive.|||

It was not that straight forward. Cluster does not use drive letters for the volume....it uses the disk signatures.

I had to use clusterrecovery.exe utility from resource kit. It is a great tool.

Regards
Rajan

|||

This technique will work just fine. I've used it many times.

In the cluster administrator stop the SQL Server and the SQL Agent.

Attach the new luns to the servers, and make them cluster resources.

Copy ALL the files and folders from the old drive to the new drive.

Switch out the drive letters so that everything looks eactly like before (just with the new drives).

Update the cluster resources lables for the drives so that they match the correct new drive letters.

Change the dependencies on the SQL Server cluster resource so that it now depends on the correct drive letters.

Startup the SQL Server and SQL Agent services in the cluster administrator.

All should be working well after that.