Thanks Perry and Jeff.

Any link to refer for understanding the process in detail ?.

(How sql server fills the empty spaces caused by deletion). Thanks again.

Sure..

Both Auto create statistics and Auto update statistics are ON.

But still it is recommending to create few statistics and indexes.

Won't go blindly by it anyway.

Thanks.

Thanks.

Me too checking the query parallel while app team comes back on this.

Checking with database Engine Tuning Adviser as well.

Thanks again Gila.

Hi,

It doesn't return any records, but does a 10798 logical read every second.

Upon checking further, indexes are missing it seems. Especially on some foreign keys.

Currently application team is analyzing that...

Thanks Gila.

Had checked those links earlier, need to brush up again.

I read, parallel query processing may badly impact cpu usage and performance of the system in OLTP system...

Thanks.

Basically CPU and memory usage is consistently high in sql server.

Was trying to figure out whats wrong.

Any scripts to check step by step for CPU/memory utilization ?

Thanks again.

Probably it could be a service in application server which continuously running.

Well, if you get this error every minute, run the profiler for a while and find the host where...

Thanks.

I scheduled it almost the same way as of now.

Set following params in the schedule.

Program/Script=powershell.exe

Add arguments (optional)=process.ps1

However, I would prefer to convert it as .bat file and schedule it.

Thanks,

San.

Thank you all.

Issue resolved.

It was happening only for one particular user database which was automatically created by some vendor application, and was working fine for other DBs.

Owner was not set...

Adi Cohn-120898 (7/22/2015)

---

In your message you wrote that you are creating a new login but in the error message it seems that you are trying to add a user as...

OK. Thanks Perry.

Hi Jayanth,

Thanks, added the disk and changed the resource group also to SQL Server.

I don't see any issues as such and is visible everywhere. The system is live now, hence...

Thanks Jayanth. Let me check the link.

Took a fresh backup and documented.

Thanks a lot Perry/Gila for clarifying all the doubts.

Learned something new, thanks for your support.

Expiry_date...