Viewing 15 posts - 601 through 615 (of 1,155 total)
This happened only for the first time or you need to restart the SQL Server everytime ? Try refreshing the DBMail from the DB_Mail Monitor.
...
May 10, 2011 at 9:53 pm
Use Perfmon and select the following Counters
SQLServer:Memory Manager -- Target Server Memory (KB) -- amount of memory SQL Server wants to use
SQLServer:Memory Manager -- Total Server Memory...
May 10, 2011 at 9:50 pm
Try this..
exec xp_readerrorlog 0, 1, 'locked pages'
Thank You,
Best Regards,
SQLBuddy
May 10, 2011 at 9:42 pm
Check this Link
http://www.mssqltips.com/tip.asp?tip=1523
You need to use
SQL Server Performance Condition Alert Type
And Object = SQL Server Databases
Counters : DataFile(s) size (KB)
...
May 10, 2011 at 9:36 pm
Try CA Autosys ... I am not sure about the price.
...
May 10, 2011 at 9:25 pm
Please be more descriptive to get quick and to-the-point responses.
...
May 10, 2011 at 9:13 pm
As Jason Mentioned, Check the Recovery Model of the database. If the Recovery mode id FULL and if you don't take Log backups or regular Log Backups , then the...
May 10, 2011 at 9:11 pm
Gail is Right. That's the reason why you are seeing more memory consumption than Max Mem.
...
May 8, 2011 at 2:31 pm
Try changing the SQL Server and Agent service accounts to Local System and try to start them on your local computer
...
May 8, 2011 at 2:29 pm
How do you know that the package failed at the compile stage itself ?
I don't think the internal steps like sending an email will be triggered if the pckg fails...
May 8, 2011 at 2:24 pm
As Gail mentioned, Fragmentation gets affected only if the Index pages are usually > 1000. With such small indexes you mentioned, reindex doesn't have any impact.
...
May 8, 2011 at 2:15 pm
Use the following counters to check the Memory consumption. You can use Perfmon or the TSQL st as shown below
SQLServer:Memory Manager -- Target Server Memory (KB) -- The...
May 4, 2011 at 7:39 pm
NOLOCK hint results in dirty reads. You should avoid NOLOCK hint in these kind of insert statements.
Follow Gail and Grant's advise. They are right.
To reduce blocking you can use...
May 3, 2011 at 4:50 pm
If that's the issue, you need to update the statistics prior to running the SP ?
BTW, how are you updating the statistics ?
...
May 2, 2011 at 7:07 pm
Gail is Right. Rebuilding doesn't have any impact on smaller indexes with pages usually < 1000.
What is the Index depth for the index ?
...
May 2, 2011 at 7:07 pm
Viewing 15 posts - 601 through 615 (of 1,155 total)