Currently, we have Dynamic ports for all the named instances on the server and the application connects to SQL Server using the the instance name like ServerName\INS1.

If I make it...

I'm NOT sure whether we can shrink the log file size for TempDB or not? I believe it's NOT a good practice...

It's a TempDB which will be always in SIMPLE recovery mode!!

Thanks

NO, On node1, we have one instance and on node2, we 4 instances and...

Is the configuration works if We configure SSL to use 1st option 1 Basic Security—Accepts http but rejects any calls that might be involved in the passing of credentials as...

Could you please advice me this

thank you

Is SQL Server 2008 Reporting Services Configuration Manager won't create Virtual directories in IIS? like ReportServer & Reports under default website in IIS?

Thanks

Sorry, it's my mistake..now I'm able to see that SSL option available in report server configuration manager. But what option I should select in "Require for" drop down

1 -...

Please see the attachment for the reporting services configuration manager tool that I can see. And I also browses the Reportserver from IIS which is asking me to enter https://

I appreciate if anybody have some inputs on this

thanks

May be it's dumb question. But where exactly should I look for the query running using sp_executesql?

Do you know the query that is being executed by the proc sp_executesql?

That proc is really what is being deadlocked. That proc is held inside the resource database and is...

processor queue length:

Processor Queue Length is the number of threads in the processor queue. Unlike the disk counters, this counter counters, this counter shows ready threads only, not threads...

Paul,

Thanks for your help. today, I noticed 3 times that Processor queue length alarms as below and process running at the time shows as Idle & which is taking all...

Thank you Jeffrey!!