sqlhelp
|
|
|
|
Like what you see? Create your own archive right now!
Data Visualizations
Click each chart to enlarge, interact & embed.
Content from Twitter
Recent Tweets From This Archive
SQLHA
sql_r
SCOM question: can the OpsMgr and OpsMgrDW databases reside on a different server from their Reporting Services instance? Thanks. #sqlhelp
SQLDBA
DBA_J
DBA_J
I have articles needed 4 transactional replicate,but dont have primary keys.Can u run merge replication psuedo transactional style? #SQLHelp
SacSQLDude
ChrisCCamp
Any good recommendations for tracking down SQL Server 08 R2 memory leaks that aren't necessarily caused by inefficient queries? #sqlhelp
sqlity
@alexf0101 use procedure signing with certificate: http://t.co/aVzteHrI I will blog about it soon... #sqlhelp
alexf0101
Is there any way to enable/disable logins through an SP, without granting ALTER ANY LOGIN to the executor? EXECUTE AS not helping #sqlhelp
Aschenbrenner
@chadchurchwell with large range scans, you can also try 128kb #sqlhelp
Aschenbrenner
@chadchurchwell Offset is beginning with Win2008 1MB by default, Block Size should be at least 64kb, if you have a DWH 1/2 #sqlhelp
chadchurchwell
#sqlhelp what is the recommended offset and blocksize for SAN disks for SQL Server
A_Bansal
I am looking for some good blogs/sites on sql server replication? any suggestions? #sqlhelp
SQL_Kiwi
@davebally For a brand new index, yes, it only becomes visible in sys.indexes once it is fully built and available for all queries. #sqlhelp
MladenPrajdic
@davebally oh cool. didn't even know that existed. thanx for letting me know! #sqlhelp
davebally
Is it fair to say that if an index is built online then it will only been shown in sys.indexes once it has been built ? #sqlhelp
venzann
venzann
SQLPoolBoy
@AaronBertrand @venzann I can confirm that it is doing exactly the same behavior on 4 different 2012 VMs I have #sqlhelp #sql2012
AaronBertrand
@venzann while I can't confirm or deny your problem, you might want to be sure your video drivers are current. /cc @SQLPoolBoy #sqlhelp
AaronBertrand
@venzann I'm not all that surprised. They don't seem to care much about the wheel. http://t.co/dAOvgDeU #sqlhelp #sql2012
venzann
#sqlhelp CLick back in query window. Does it remember the database you selected, or switch back? Just wanting to verify my quirk
DBA_J
some articles I want to transactional replicate dont have primary keys. Can you run merge replication psuedo transactional style? #SQLHelp
AaronBertrand
@christeyomik8 calendar table is probable easiest and applicable to many other problems too. http://t.co/TBVuiZmK #sqlhelp
christeyomik8
Anyone have a scripts that will give me the dates of every Monday for the year? sqlhelp
AnupWarrier
@SQLPoolBoy Thanks Jonathan for that confirmation,Greatly appreciate that #sqlhelp
mrdenny
@cheriansnet you'll need to look at stuff like SCOM to do monitoring like that probably. #sqlhelp
philcart
@SacSQLDude need to restrict policy to single server and want to know how I can test the condition to see what is returned #sqlhelp
cheriansnet
SQLPoolBoy
@AnupWarrier you only get 4 replicas (1 primary, and 3 secondaries) per AG though #sqlhelp
SQLPoolBoy
@AnupWarrier I haven't seen anything. You can put a lot of DB's in a single AG, and I've had as many as 4 AGs in a single instance #sqlhelp
AnupWarrier
Can someone confirm on the Max No of Availability Grps/Instance and Max no of DB's/AG for SQL 2012.Anything published as of now? #sqlhelp
philcart
Using SQL 2008 R2, what's the best way to test a condition for a policy? #sqlhelp
MartinCairnsSQL
@SQLJay You can also sign the sp with a cert for cross database access http://t.co/6vbSxt1t #sqlhelp
vickyharp
@SQLTentMaker Actually that's a great question and one I should ask. Thanks! #sqlhelp
DataRealized
@SQLPoolBoy Based on odd PLE's by NUMA and differing c3 time wondering if 10 core box has issues. perf isn't as i'd expect. #sqlhelp
SQLPoolBoy
@DataRealized Sorry, that is one of those things that is troubleshooting more in the edge case realm of problems. #sqlhelp
SQLPoolBoy
coffegrl
DataRealized
@SQLPoolBoy Well, if I end up enabling it, I'll let ya know what I see. #sqlhelp Thank you
ZenDada
I want to visualize the job schedule... start times... average duration... of all jobs on a server. Tips? #SQLhelp
SQLPoolBoy
@DataRealized what problem are you trying to troubleshoot? Maybe it would be better to backup a level here. #sqlhelp
SQLPoolBoy
@DataRealized Nope, no idea. I've never turned it on in a production environment, only used it in demos while teaching. #sqlhelp
DataRealized
@SQLPoolBoy Right... any idea on how much it will impact perf? 20% increase in load? 5%, 50%? :) #sqlhelp
SQLPoolBoy
@DataRealized sorry have my TFs confused. 842 is needed to populate sys.dm_os_memory_node_access_stats and yes it can impact perf #sqlhelp
DataRealized
@SQLPoolBoy That's trace flag 834 you are referring to I'm pretty sure. I'm asking abou TF 842. I already have 834 enabled #sqlhelp
SQLPoolBoy
@DataRealized if MSFT is recommending it to you, then I'd say enable the TF, once you do, the buffer pool is not dynamically sized #sqlhelp
SQLPoolBoy
@DataRealized no, it could improve perf by reducing TLB misses because your granularity is not 4K but 2MB #sqlhelp
DataRealized
@SQLPoolBoy I know... working with MSFT on a case and I'm not sure i's accurate.TF causes a perf hit, doesn't help perf, right? #sqlhelp
SQLPoolBoy
@DataRealized there are counters in SQL that show if foreign memory is being used/referenced #sqlhelp
SQLTentMaker
@vickyharp That is a lot of history rows. 500 Million? Is distribution cleanup job running? #sqlhelp
DataRealized
@SQLPoolBoy It is NUMA aware (8 nodes) -- Trying to determine remote page lookups and read / write count per NUMA node. #sqlhelp
SQLPoolBoy
@arcanecode so you can patch one instance and have the other still handling the reporting requests? #sqlhelp
arcanecode
Can anyone think of a good reason to run multiple instances of SSRS in a scale-out scenario but all on the same server? #sqlhelp
SQLPoolBoy
@DataRealized interested to see evidence that it made a significant performance impact if you test it. #SqlHelp #SQLServer
SQLPoolBoy
@DataRealized a server with 1TB RAM should be NUMA aware and that already subdivides the memory across nodes #SqlHelp #SQLServer
SQLPoolBoy
@DataRealized it requires that the buffer pool be allocated entirely at instance startup and it has to be contiguous #SqlHelp #SQLServer
SQLPoolBoy
@DataRealized 842 is a benchmarking special that is documented because they use it in TPC benchmarks #SqlHelp #SQLServer
SQLPoolBoy
@JeffMlakar There are a few of them out there depends on whether you want to pay for it or not. http://t.co/2mpY8kja #sqlhelp
vickyharp
@SQLTentMaker Seems to be a problem even with low # of pending xacts. Delay is getting most recent xact seq no from history. #sqlhelp
JeffMlakar
Is there a source of data somewhere that lists offset-from-UTC per City (preferably not by longitude/latitude)? #sqlhelp
DataRealized
Performance impact of TF 842 on SQL 2K8 with 1TB of ram? Any experience or guidelines? #SqlHelp #SQLServer
SQLPoolBoy
@BrentO @NHeyen @unclebiguns changes in SMB 2.2 make UNC paths more viable performance wise http://t.co/PCXHtlfR as well #sqlhelp
SQLTentMaker
@vickyharp I'm assuming you have a lot of pending transactions to be distributed. Correct? #sqlhelp
vickyharp
@SQLTentMaker Also seeing same issue with MSrepl_transactions but was not sure if there were special gotchas with history. #sqlhelp
vickyharp
@SQLTentMaker Takes a long time to get subscription latency. Got a plan showing 207 estimated vs 500 million actual in history. #sqlhelp
SQLTentMaker
@vickyharp Got it. What exactly are you troubleshooting with monitoring? #sqlhelp
vickyharp
@SQLTentMaker Indeed, that is also mentioned at the link. I'm troubleshooting replication monitoring, not replication itself. #sqlhelp
SQLTentMaker
@vickyharp I would be more concerned with getting stats updated on msrepl_commands than msdistribution_history. #sqlhelp
mrdenny
@vickyharp There shouldn't be any problem updating the stats on that table either. #sqlhelp
vickyharp
I see guidance here http://t.co/vZ6pi61k on updating stats for MSrepl_transactions. Ok to do same for MSdistribution_history? #sqlhelp
NHeyen
@unclebiguns read that but looking for an example, never tryed this before know it is a bad idea
#sqlhelp
Want to see all the tweets from this archive? Download the archive!
