hi all,

I will soon be moving to a new company as their SQL Server DBA. They use Lawson on a Windows server.

Will I be limited to using the built-in Lawson tools for adminstering the database, performance tuning, etc...... or can I use what I've used for years such as SQL Server's Enterprise Manager, Profiler, Management Studio ?

Maybe another DBA out there can answer my question.

Thanks, John

john,
what version of lawson are they on? I was a SQL Server DBA for a few years but never for Lawson, however I have dealt with Lawson instances on SQL Server and it seems you still have the ability to use SQL Servers tools for performance tuning, however I dont think its as straight forward as you might think.

If you are familiar with Lawson then you know that its not a typical 3rd Normalized form relational database. I think its -100 Normalized form <joke>.

Im not familiar with the db reorg tools used in lawson so I cant help you there, perhaps some of the other admins can shed some light?


hth,
matt

I often have this discussion with DBAs from all the supported RDBMS. The answer is a definite "maybe"

Let me explain... Since Lawson is really database agnostic it has to maintain all it's information internally, so there are Lawson tools and practices that have to be followed so that Lawson KNOWS where it's data is, how it's indexed, what it's relations are and how to use them, so I STRONGLY suggest that you pick up the Lawson DBA course for SQL Server, and keep a copy of the SQL Server for Lawson manual handy.

Now, when it comes to tuning, backups, data migration, etc.. you can bet that you'll find the SQL tools far superior to Lawson's - so use them! But you'll need to be sure that you are meeting Lawson's needs as well and not just do things the "MSSQL" way.

I've found that after a little initial frustration(:banghead: ), while getting to understand Lawson, most DBAs eventually settle into an understanding relationship :bonk: with the system.

Welcome to the Lawson family and good luck.

Thanks for the replies Matt and schroncd. I'm at the job now.

This is Lawson 9 using SS2005

You can bet I'll be posting back here with more questions later.

Thanks again. John