x86-32 is where we are now.

What are the factors that should influence going for 64bit environment.?

Thanks Gail. It makes sense.

Gus

1)

When you use FP numbers for money values, do you use convert statements to trim the scale - is this what mean by 'take necessary steps to make sure precision...

Eddie

AWE is enabled, and I just wanted to check through t-SQL code if it is possible to determine 'LPIM' option.

How much max physical memory can be added in 32bit vs...

Gail,

Thanks for the audio link. You would recommend to start with these basic counters for any server, too?

I asked my SysAdmin and she says that the SAN Storage for...

just want to make sure I got it:

so if I reset the errorlog, then I should be able to see the setting/option for LPIM in the erorrlog right after that,...

Gail

I just saw your post to David. So I will coast on the 'Disk Length' till after I hear the audio.

Dan

Gail

This server was not monitored before; hence I am trying to create a baseline, at the same time, the users are complaining of slow reads in the reporting.

What majorly concerns...

That is good info. But what is the relation between "lock pages in memory" option and errorlog. Are you saying the info on the option would be in the first...

Thanks..

can you please explain your statement "You will not find this info is the errorlog has been rolled over.

e.g. using "EXEC sp_cycle_errorlog" or "DBCC errorlog"". Are you saying that I...

wanted to have the list of permissions enabled on the service account.

how will the events help me, in this case?

lock pages in memory is not available with sql2005 Ent edition 32 bit?

Steve, Jeff

With decimal and Numeric being the same,

http://msdn.microsoft.com/en-us/library/ms187746.aspx

there is no other choice, for these kind of data, right? with the only decision to make will be how...

Seth,

sometimes, a long running query with heavy order & grouping, bloats out TempDB. So I was thinking TempDB is the temp storage for the processor to order the results, also....

Seth

yes, another major use of TempDB; but I guess a developer can go overboard on using too many of TempTables, too, right, and thus bloating the TempDB.

Dan