Comments
Sort by recent activity
Daniel,
If you are using DBCC SHOWCONTIG too how would I be getting different results when I run it locally?
Even straight after a recommendations refresh (hourly) the results shown in SQL Response are quite different from the results I get in SSMS.
Jonathan / comments
Daniel,
If you are using DBCC SHOWCONTIG too how would I be getting different results when I run it locally?
Even straight after a recommendations refresh (hourly) the results shown in SQL Response...
details showing SSMS with one index fragmented and SQL Response showing 12 emailed. / comments
details showing SSMS with one index fragmented and SQL Response showing 12 emailed.
Hi, me again!
Are you using sys.dm_db_index_physical_stats with just the filters as per the recommendation settings - eg 50% + 16 pages..? Thats the closest I can find to match by results with DBCC ... / comments
Hi, me again!
Are you using sys.dm_db_index_physical_stats with just the filters as per the recommendation settings - eg 50% + 16 pages..? Thats the closest I can find to match by results with DBCC...
nothing really stands out;
I would sort it by the mem usage or VM size columns if I could so as to see the worst offenders ... feature hint [image]
I would send it to you if I could select from that pane and paste into Excel ... feature hint [image]
I dont know what would be normal for any of the 70+ processes on the servers though .
background:
Servers A and B host OLTP and OLAP activities for our main company system (maybe max 200 concurrent users via 2 IIS servers),
Server C supports all other database services for the company - 45 databases, max 10-20 concurrent users in maybe 3 or 4 of these systems - HR, Accounts, Intranet, etc., )
certainly both server (h/w) are doing very different things and are (at this time of day) totally unconnected. Over night there are data transfer scripts that run. / comments
nothing really stands out;
I would sort it by the mem usage or VM size columns if I could so as to see the worst offenders ... feature hint
I would send it to you if I could select from that pane ...
Daniel,
the pie chart that shows SQL Server 18.4 GB, other processes 1.4GB and other 192MB on servers A + B (they are set to have a maximum of 9GB each, thus leaving 2GB for OS etc) at 10:14:24
and for server C ...
at 10:14:19 SQL Server 6.3GB, other processes 1.5GB, free 235.1MB
regards
Jonathan / comments
Daniel,
the pie chart that shows SQL Server 18.4 GB, other processes 1.4GB and other 192MB on servers A + B (they are set to have a maximum of 9GB each, thus leaving 2GB for OS etc) at 10:14:24
and...
I have a registered version and its got a (tiny) pile of books as the icon... the difference between registered and trial maybe?? / comments
I have a registered version and its got a (tiny) pile of books as the icon... the difference between registered and trial maybe??
I also have seen recommendation details where the check cycle is every 1.0 hours but the Last checked value is something to the order of x days ago.
It seem transient in so far as over time the Last checked will return to < 1hr.
As they are recommendations, in most cases, I have them in hand as work to do anyway so I am not too concerned if the parameter isnt checked 24 times a day...
Jonathan / comments
I also have seen recommendation details where the check cycle is every 1.0 hours but the Last checked value is something to the order of x days ago.
It seem transient in so far as over time the Las...
For the whole thing:
select SQL Prompt drop down menu and then Cache Management
but be ready for a lengthy wait as it will refresh the details for all databases you have visited.
The method I use is when i connect to a database and things are out of whack, hit Ctrl+Shift+D. I small overlay screen appears in the bottom RHS of the screen and SQL Prompt scans the whole db.
HTH
Jonathan / comments
For the whole thing:
select SQL Prompt drop down menu and then Cache Management
but be ready for a lengthy wait as it will refresh the details for all databases you have visited.
The method I use i...
Hi Ed,
I have never had key combination shortcuts fail in SQL Prompt so I dont think I can help you much further. Maybe try/ensure:
- all three keys are pressed together, not in one after the other
- are you on the latest release?
- have you tried an uninstall/re-install?
- do other shortcuts work/has the Ctrl+Shift+D ever worked?
Jonathan / comments
Hi Ed,
I have never had key combination shortcuts fail in SQL Prompt so I dont think I can help you much further. Maybe try/ensure:
- all three keys are pressed together, not in one after the other...
My reasoning behind similar behaviour is that if the script i have doesnt parse then the hints seem not to function.
When you get the problem next time try hitting Ctrl+K, Ctrl+Y to see if the layout feature works. My experience shows that this fails with a SQL parse error. Also try the 'Parse' tick button next to execute in the defaul SSMS toolbar.
Fix the script 'error' and see what effect this has on the hints feature ...
[I put error in inverted commas there as sometimes is not an error as in a mistake but an error as in an incomplete section of code.]
Jonathan / comments
My reasoning behind similar behaviour is that if the script i have doesnt parse then the hints seem not to function.
When you get the problem next time try hitting Ctrl+K, Ctrl+Y to see if the layo...