Viewing 15 posts - 16 through 30 (of 706 total)
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.
October 1, 2015 at 9:42 pm
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.
August 31, 2015 at 1:00 am
Me too checking the query parallel while app team comes back on this.
Checking with database Engine Tuning Adviser as well.
Thanks again Gila.
August 30, 2015 at 9:39 pm
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...
August 28, 2015 at 12:48 am
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...
August 26, 2015 at 4:11 am
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 ?
August 26, 2015 at 2:59 am
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...
August 19, 2015 at 4:29 am
I scheduled it almost the same way as of now.
Set following params in the schedule.
Add arguments (optional)=process.ps1
However, I would prefer to convert it as .bat file and schedule it.
August 12, 2015 at 2:59 am
Thank you all.
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...
July 23, 2015 at 3:49 am
Adi Cohn-120898 (7/22/2015)
July 22, 2015 at 4:22 am
OK. Thanks Perry.
July 20, 2015 at 9:41 pm
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...
July 20, 2015 at 4:31 am
Thanks Jayanth. Let me check the link.
July 20, 2015 at 3:39 am
Took a fresh backup and documented.
Thanks a lot Perry/Gila for clarifying all the doubts.
Learned something new, thanks for your support.
July 15, 2015 at 4:03 am
What's the state of the current certificate has that expired. It looks as though an old expired cert has been replaced by a new one, but you'll need to confirm
July 15, 2015 at 12:28 am