I tried this and its working fine.

Thanks for sharing.

But the result in the file is in improper manner.

But i can say a bit....

In your case restart of SQL Server services is not a final solution, you have to assess the baseline of performance monitoring of your application...

To check the memory usage of SQL Server, you can just simply look into Task Manager for SQL Server Memory and CPU utilization.

Pretty good error... let me check if...

what actually you are trying to do ?

SQL Monitoring depends on manythings to do. Its not a bit or a line to do so.

Its like a research on SQL Server...

Hi,

I also faced the same in the past of CPU 100%

Try this query to get the top most executed queries in you server. Monitor the same for a day and...

If you want to delete the job, you can do that manually.

Try :

select * from sysjobs

delete from sysjobs where name = '<>' or Job_ID = <>

hope it will work.

Can anyone suggest how to work with Report Server - reports using GMAIL (smtp.gmail.com)

Check SQL Server Erroor Log for the exact error and reason.

Try to update the Services LogOn password again, if the services are running with any LogOn account. Restart the services once updated.

What is the exact error msg you are facing...

Try checking with the system memory.

Set TempDB recovery mode to Simple.

Check the drives have enough space.

Just Gone through earlier posts and tried.

I successfully created DBMail Setup using smtp.gmail.com,

with basic authentication of my GMail account and password,

Created a profile using a server name : smtp.gmail.com,...

Dears,

Finally I found one solution to connect the instance remotely.

"servername\Instance,portnumber"

It worked fine.

Thanks for all of your support.

Did you try using a command line tool instead to connect, like: osql -E -S tcp:servername\instancename?

Also, under network configuration-->TCP/ip, did you check and see if it is holding the latest...

Yes done.

Rebooted, twice. Not able to figure out. Iam able to connect my local instance in the server. Still, the server instance is not able to in remote.

Tried already.

Added alias with the port, but it still the same issue.