The Ram is total 96 GB. The max memory we set is 83 GB.

Today when we tried to login to the server at day time, we found it is slow...

Thank you, you are awesome.

Now I remember I created that procedure in one of the new server, forgot I have to change the profile name.

Without you know that, I will...

Thank you , it works for me.

I found this one.

http://logicalread.solarwinds.com/best-practices-sql-server-virtualized-dc01/#.Vtch3U3ruig

Thanks all.

I cannot access the page,

https://sqlbits.com/Sessions/Event10/Deciding_if_Virtualization_is_a_good_choice_for_your_servers

Could you provide the link again.

Thanks

Thank you so much Hugo for your detailed advice, I learn a lot.

Thank you, good advice.

One more question, they also need to add a notification table, basically for each item too, such as notification for Hearing, notification for workshop, notification for invervention....

Thank you, a further question about the database.

For the new application data, it will be good and clean, if we create a hearing note, in the table of HearingNote,...

First, thanks every one for your patient and detailed answers. All your answers are very helpful. I really learn a lot from this.

We are not going to have many queries...

Thanks...

If a note belongs to a single object (either a hearing or a conference or a workshop or an intervention), then use:

Notes table: Noteid, NoteDetail, NoteDate, CreateDate, createdby, HearingID, ConferenceID,...

Also if I create a Notetable for each Object, what name should be called?

For example:

I have conference table,

Then I created a ConferenceNote table. It will be NoteID, notetype, ConferenceID,

In the...

so is it going to be something like this?

Note table: Noteid, NoteDetail, NoteDate, CreateDate, createdby

NoteBridgeTable:

columns: NoteID, NoteTypeID, Objectid (cannot find a good name for it)

Data:

Noteid, notetypid, hearingid

Noteid, notetypid, conferenceid,

Noteid,...

Thank you Hugo, Ed Wagner and Sergiy for your posts about using the entityid.

I kind of suspect at the very beginning the benefits of using entityID , esp, table...

Thanks all for the good tips.

Let me take a close look and may get back to you.

We originally did go the route that creates a note table, with NoteID and...